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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.