HI All I need to get pdf data in to excel below screen shoot details for your reference as a new user I am unable to upload text file But i have given screen shoot with selecting the data need to be in columns of excel . any reply or assistance is appreciated [INPUT DATA AND PROCEDURE REQ]

@srilakshmi_Tippireddy - I will try my best to provide the patterns by looking at the pic… TO: (?<=TO\s?:).*(?=\sINVOICE) For the above use…Regexvar(0).value.trim… INVOICE NUMBER = (?<=ISSUE DATE\r\n\s+)\w+ ISSUE DATE = (?<=ISSUE DATE\r\n\s+\w+\s+)\w+ CUSTOMER CODE = (?<=DUE DATE\r\n.*)\S+(?=\…

PDF content in to in to excel table

Help Studio

prasath17 (Guru) April 24, 2021, 2:14pm 4

@srilakshmi_Tippireddy - you have 2 options…

Document Understanding
As explained by @wasea

Check this post …where One value was extracted using ex.rate

1 Like

Topic		Replies	Views
Extract specific text from pdf to excel Help	12	2813	June 11, 2019
Text to excel- Data manipulation using Regex(VB code) Activities excel , pdf , question	8	1299	March 15, 2021
Extract PDF Invoice Data to Excel StudioX studiox , question	2	1764	February 3, 2022
How to extract data from PDF and save it in excel Studio uiautomation	6	971	February 22, 2023
Can anyone please help me to extract data from pdf and store in to excel Studio studio , question , activities_panel	1	560	October 18, 2022

Most Active Users - Yesterday
ashokkarale
jast1631
Shruthika_r
justindward
Gaurav_Malhotra
More details...

PDF content in to in to excel table

Related Topics