Regular expression help for segregate special character

[Duleepa_Krishan]

Hi all, I am newbie Uipath, I have a data table with following value and I need to take only the value prior to the “_” special character,

Ex-
1988411_YM2021-189
1988399_NY2021-1120
1988397_YK2021-312

Output need to be
1988411
1988399
1988397

Thanks in advance

[copy_writes (chethan)]

Use the regex
.*(?=_) or use ^\d+

Regards
Chethan P

[ppr (Peter Preuss)]

@Duleepa_Krishan

Ex-
1988411_YM2021-189
1988399_NY2021-1120
1988397_YK2021-312

[copy_writes (chethan)]

Or use split or Substring Also
VariableB=VariableA.substring(0,variable.index(“_”)

Note VariableA is your text

Please Mark it as Solution

Regards
Chethan P

[NIVED_NAMBIAR (NIVED N)]

Hi @Duleepa_Krishan

you can try this regex pattern [ more precise it seems]

Regards,
Nived N

[Duleepa_Krishan]

Thanks Its worked like a charm

[copy_writes (chethan)]

You are welcome What @ppr And @NIVED_NAMBIAR They also right you can follow there code

[Duleepa_Krishan]

Thanks

[Duleepa_Krishan]

Thanks!