Parsing text string into 2 pieces in database | Experience Community
Skip to main content

Parsing text string into 2 pieces in database

  • February 12, 2021
  • 1 reply
  • 12 views
L

Hi all
Long story but I had to combine 2 emails addresses into 1 field for our automated response action (when given a bad review for a site interviewed). e.g. joesmith@generic.com, joesmith2@generic.com.
I now need to find a way of splitting this field into its 2 parts in the Qualtrics database if possible - I need to grant viewing permissions on a dashboard and rather than allocate these manually (1000+ permissions) I want to base these on role permissions based on email (now limited due to being combined).
Is this possible at all?
All info TRULY appreciated

    1 reply

    PraDeepKotian_XM
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+21
    • PraDeepKotian_XM
    • QPN Level 5 ●●●●●
    • February 12, 2021

    Hi Lee1982
    If your emails are separated by any delimiter like comma(,) than you can save this filed as Multi-Answer Text set in dashboard mapping and from the Recode editor options, you can set the delimiter accordingly.
    Hope this helps.

    PK
    Terms & ConditionsAccessibility statement