How To Select Specific text

How To Select Clint Id number ,Account number and Account amount

image

Use get text Activity
or
If it is a pdf,text or image u can use regex to extract the value

2 Likes

It is text Not a pdf

Hi @saileela

Then you can use the regex for that

Can you share the text file !

(?<=Client ID:\s+)[A-Za-z]+\d+ ----->EXtract Client ID

image

(?<=Account Number:\s+)\d+ -------------->Extract Account Number
image

(?<=Account Amount:\s+)\d+ ------>Extract Account Amount
image

Hope you find it helpful!

Regards,

2 Likes

@saileela

“(?<=:)[a-zA-Z0-9]+”

system.text.RegularExpressions.Regex.Matches(str_input,“(?<=:)[a-zA-Z0-9]+”)
MatchCollection(9) { [RX451561], [156796], [15798626CAD], [RX451561], [156796], [15798626CAD], [RX451561], [156796], [15798626CAD] }

give you match collection

Hello @saileela

Try with this Regex Expression :

Hope it helps :slight_smile:

Or if u want to extract all the specified values at once ,then use this,
(?<=Account Amount:\s+)\d+|(?<=Client ID:\s+)[A-Za-z]+\d+|(?<=Account Number:\s+)\d+

2 Likes

Hey @saileela ,
Kindly refer below xaml

Regex.zip (3.0 KB)
Hope it helps you out

HI @saileela

you can with this xaml

Regex with text.zip (1.9 KB)

for your refence you can see the screenshot

image