How to Split using Regex expression

[pranil2k2]

Hi,

I need some help on spliting the user name on basis of Regex expression.My user Name is an combination of mutliple users and i cant use comma to split them. so, i tried regular expression and which is working good on DB level and planned to implement same in Snaplogic, but it is not working. Please some one can help me here.

[cjhoward18]

rsramkoski:

john, maria,lisa, awari,Arun, john(TCS)

Hi @pranil2k2

Here is an expression that produces the results you are looking for:

$NAME.match(/[^,]+,[^,]+/g)

[pranil2k2]

HI,

Thanks for the information.

Anil

[pranil2k2]

Hi,
so by doing above can I except the result will be like three rows as below?
john, maria
lisa, awari
Arun, john(TCS)

[pranil2k2]

The names are combination of first name and last name saperated by comma. so the output will be like
john, maria (first name, last name)