Read specific data from the PDF and write to CSV file

[veerishu (Veeresh Uppin)]

Hi AIl… l need to read specific data from the PDF (Highlighted in yellow) and write the data to the CSV file. Kindly help.

Read PDF:

Write CSV

[veerishu (Veeresh Uppin)]

Attaching the PDF test11.pdf (227.8 KB) for reference

[Pradeep_Shiv]

if the PDF Format Remains Same we can do it

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv Yes, the PDF format remains the same

[Pradeep_Shiv]

are you from Emids??

[Pradeep_Shiv]

Employee ID Format??

[Pradeep_Shiv]

This Will give you Employee ID : [A-ZA-z]+\d{3,4}
This will give you Name : (?<=Mr.|Ms.|Mrs).*

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv Employee ID Format is also the same as show in the screenshot “INEMP234*”

[Pradeep_Shiv]

Do onething Write that file in TextFormat and Send

[veerishu (Veeresh Uppin)]

@Pradeep_ShivTest.txt (1.7 KB)

[Pradeep_Shiv]

make True for Preserve Format in ReadPDFText activity Property Panel and send

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv Can you elaborate on this plz

This Will give you Employee ID : [A-ZA-z]+\d{3,4}
This will give you Name : (?<=Mr.|Ms.|Mrs).*

[Pradeep_Shiv]

in this fromat its quite tough

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv Could you help me get only INEMP913 from the string

“Ref: HR/Personal File/INEMP913/4-6 November 3, 2011”

[Pradeep_Shiv]

is INEMP is Fixed???
@veerishu

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv YES

[Pradeep_Shiv]

regex101: build, test, and debug regex

Click on the link its working you can check
INEMP\d{3,4}

[veerishu (Veeresh Uppin)]

@Pradeep_Shiv : Thanks for your valuable time and help.

However, the below code helped me solve my problem.

StartIndex = InputData.IndexOf(“WORKED HOURS”)

EndIndex = InputData.IndexOf(“SPECIAL PAYMENTS”)

WorkedHours = InputData.Substring(StartIndex,EndIndex-StartIndex).Trim

[Pradeep_Shiv]

good