Five Stars

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.

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: Using tExtractRegexFields to Extract 1 to n names from field

Hi,

 

Please try below.

 

Split_Reg1.PNGSplit_Reg2.PNG

 

Please let me know if you have any issues.

Regards,

 

Veeru Boppudi
2 REPLIES
Nine Stars

Re: Using tExtractRegexFields to Extract 1 to n names from field

Hi,

 

Please try below.

 

Split_Reg1.PNGSplit_Reg2.PNG

 

Please let me know if you have any issues.

Regards,

 

Veeru Boppudi
Five Stars

Re: Using tExtractRegexFields to Extract 1 to n names from field

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