Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using tExtractRegexFields to Extract 1 to n names from field

I have a field called FirstName, this field contains First Names and also First/Middle/Last separated by forward slashes. Example: Carolus/T/Holman. I need to split this on the Slash. Ii have tried a few things but nothing is working. I need to get the RegEx code to split the Field. I have also tried the tExtractDelimitedFields with the same results. 

 

Thanks.

Labels (2)
1 Solution

Accepted Solutions
vboppudi
Partner - Creator III
Partner - Creator III

Hi,

 

Please try below.

 

0683p000009Lt5Q.png0683p000009Lt5V.png

 

Please let me know if you have any issues.

Regards,

 

View solution in original post

2 Replies
vboppudi
Partner - Creator III
Partner - Creator III

Hi,

 

Please try below.

 

0683p000009Lt5Q.png0683p000009Lt5V.png

 

Please let me know if you have any issues.

Regards,

 

Anonymous
Not applicable
Author

I thought the output was self-mapping, when I added expected columns, then the component worked. Thank you.