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...
pranil2k2's avatar
pranil2k2
Contributor
6 years ago

Hi,

The best example is below, it have three names separated by comma, so I thought of using some logic as
“regexp_substr(dossier_lead, ‘[[:alnum:] .()-]+, [[:alnum:] .()-]+’,1, level,‘i’)” it is working in oracle but it is hanging, so i thought of trying same logic in snaplogic.

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

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