Extract the Data with Regular Expression

Help Studio
, , , , , ,
1

Hi Team,

Here i am trying to Extract the Data with Regular Expression, but it is giving the Empty Values.

Text to be Extracted :slight_smile:

Image_Text

Input File:

file (1).txt (3.3 KB)

Thanks and regards,
Adarsh

2

Hi @adarsh_kotagiri ,

Could you let us know what is the Regular Expression that you have used ?

Also, Let us know If G is a constant word that would be present in the data ?

3

Hi @supermanPunch

I have used "(?<=[A-Z]{1}\s).* " this expression lookbehind the G, Here the G is not Constant it will be Dynamic.

Regards.
Sai adarsh.

4

@adarsh_kotagiri ,

Could you give more info on what are the constants that we can use in the text ?

We could check with the date in the next line and capture the previous line, but in the data provided the last lines of data does not have the date, is it also the case that the date is not present and we would have to extract that data as well ?

image
image663×534 30.5 KB

5

Hi @supermanPunch

Yes, Every time in the Last line Date will get missed.

Regards,
Adarsh

6

Hi @adarsh_kotagiri , Check this below attached workflow,

Uipath_Regex_Extraction.xaml (5.7 KB)

I have used the text file which you provided and tried to extract the details which you required.

Hope this may help you :slight_smile:

3 Likes
7

Thank you @Manish540 Code is Working Perfect, Thank you for your time.

Regards,
Sai adarsh.

8

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