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.
i used ‘Get Visible Text’ activity to extract this part, and get a text string like this:
i can’t split what i want from the text.
Can someone help?
Its better to use read pdf activity.
please provide a sample pdf so that i can share the xaml
Use Read PDF activity and the entireresult stored in a string, then do some string manipulation to retrieve the desired fields
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.
Hi @Ma_Stephen_External ,
To get name and address you can use regex.
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…