Asking help to extracting data from PDF

Help Activities
, ,
1

image
i have a pdf file contains part like picture above. what i want to do is to extract ‘End User Name and Address’, ‘Reseller Name and Address’ like picture below.

image
image1259×195 15.8 KB

i used ‘Get Visible Text’ activity to extract this part, and get a text string like this:
image
image1362×93 6.07 KB

i can’t split what i want from the text.
Can someone help?

2

Its better to use read pdf activity.
please provide a sample pdf so that i can share the xaml

3

Use Read PDF activity and the entireresult stored in a string, then do some string manipulation to retrieve the desired fields

4

1.pdf (73.0 KB)
sample pdf is like this. And what i want to extract is:
End_User_Name=‘Luminor Capital Pte Ltd’;
End_User_Address=‘8 Marina Roulevard #13-02 Marina Bay Financial Centre Tower 1 Singapore 018981’;
Reseller_Name=‘Rammp It Solutions Pte Ltd’;
Reseller_Address='BLOCK 168 #05-1411 HOUGANG AVENUE 1 Singapore 5368 Singapore,SG01;

Thanks for help.

5

Hi @Ma_Stephen_External ,

To get name and address you can use regex.

System.Text.RegularExpressions.Regex.Match(strTest,“(?<=Name: )\S+.“).value
System.Text.RegularExpressions.Regex.Match(strTest,”(?<=Address: )\S+.”).value

6

but when use read pdf activity, it will extract pdf data as a string row by row. The address may cantains multiple rows. So different fields are mixed together, hard to split…