Regular expression help for segregate special character

Duleepa_Krishan · May 21, 2021, 10:33am

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 · May 21, 2021, 10:37am

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

Regards
Chethan P

ppr · May 21, 2021, 10:38am

grafik

copy_writes · May 21, 2021, 10:39am

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 · May 21, 2021, 10:40am

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

Regards,
Nived N

Duleepa_Krishan · May 21, 2021, 10:41am

Thanks Its worked like a charm

copy_writes · May 21, 2021, 10:43am

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

Duleepa_Krishan · May 21, 2021, 10:44am

Thanks

Duleepa_Krishan · May 21, 2021, 10:44am

Thanks!

system · May 24, 2021, 10:44am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.