How To Select Clint Id number ,Account number and Account amount
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
(?<=Client ID:\s+)[A-Za-z]+\d+ ----->EXtract Client ID
(?<=Account Number:\s+)\d+ -------------->Extract Account Number
(?<=Account Amount:\s+)\d+ ------>Extract Account Amount
Hope you find it helpful!
Regards,
2 Likes
“(?<=:)[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
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
HI @saileela
you can with this xaml
Regex with text.zip (1.9 KB)
for your refence you can see the screenshot
