DataScraping Regex

Help Robot
, ,
1

Hi, I am new to RPA and this Forum as well. I need your help. I am sharing a note pad which has 100’s of data

Eg:
…
deal :0
MT:876
Send:abc
Receive:xyz
Date:01 April 2022
Time:00:00:90
FT:A
Text:
MOR:7654
TRN
342
RR
0006
Narrative
ATTR:Grand
Letters of Advice

deal :0
MT:678
Send: xyz
Receive:cyz
Date:01 May 2022
Time:00:00:56
FT:A
Text:
MOR:8765
TRN
890
RR
0008
Narrative
ATTR:Gra
Letters of Advice

deal :0
MT:900
Send: uyz
Receive:cbz
Date:01 February 2022
Time:00:00:16
FT:A
Text:
MOR:8125
TRN
120
RR
0088
Narrative
ATTR:GRATEE
Letters of Advice

Now I want to convert this text into an array, iterate it through a loop and scrape relevant data like MT, send, receive, date, time, the number which is below TRN, number below RR, and the word Grand from Narrative and need to update all this data into an Excel. Here I need to use Regex Matches Activity.
I am not aware of Regex Activities Can anyone help me please. Thanks in advance.

2

@loginerror

Looping in for the duplicate topic.

3

Hi @honey.123.631
Please find below image for your reference

image
image455×572 7.65 KB

Regards,

4

Thank you @lrtetala from this i am not able to generate TRN, RR and Narative as the numbers which I want are in the next line, Like I want 342,0006 and Grand, please help me

5

try replacing for that particular fields \n with \r?\n

Regards

6

I tried but its not happening

7

or try \s+ instead of \n

also give what exactly you are giving for expression

Regards

8

TRN - (?<=TRN\n)[0-9]*
RR - (?<=RR\n)[0-9]*

9

For TRN - ((?<=TRN\n)[0-9].*).Value but its not working

10

It is working for mine. Please check below sc.

image
image1279×849 72.4 KB