Forum Discussion

pranil2k2's avatar
pranil2k2
Contributor
6 years ago

How to Split using Regex expression

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 w...
RogerSramkoski's avatar
RogerSramkoski
Employee
6 years ago

Thank you for the additional information. I believe there was a typo in the initial post indicating that you could not use commas. If your JSON was something like “names” : “john, maria,lisa, awari,Arun, john(TCS)” you could use the expression $names.split(‘,’) which will result in a “names” array. If you want to remove the white space you could use $names.replaceAll(’ ‘,’‘).split(’,').

Screenshot of split only:

Screenshot of expression with replaceAll and split:

pranil2k2's avatar
pranil2k2
Contributor
6 years ago

Hi,
I tried above solution, but i am getting output as below

.

but the excepted output will be combination of first name and last name (john, maria).

Any advice. Thanks

  • cjhoward18's avatar
    cjhoward18
    Employee
    6 years ago

    Hi @pranil2k2

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

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

    • pranil2k2's avatar
      pranil2k2
      Contributor
      6 years ago

      HI,

      Thanks for the information.

      Anil