Extract data fromPDF

Hello guys, do you know how to extract this data from PDF?
Thank you

2 Likes

@Aluneth_X You can use regular expression to extract the data

1 Like

Hi @Aluneth_X

you can use this as your reference.

cheers :smiley:

Happy learning :smiley:

4 Likes

First install PDF Activities from Package Manager.
After that you can use Read PDF activity, and place that information inside a String variable.
After that you can use Regex and String manipulation to extract the information :slight_smile:

3 Likes

image
i did extract the pdf using regex
do you know how to get only 08.05.2019 ?

3 Likes

Since all of these are of same Date format, you could split them using .Split(" "C) String method, and then select the 4th element (at position 3) of array

2 Likes

can you help me with that sir?
i save the output to variable name ‘ExtractedDate’

i don’t understand the split method
thank you

2 Likes

@Aluneth_X Spli by using new line as follows

Assign v1= v1.Split("\n".ToCharArray)(3)

1 Like

i did, but it throws error like this
image

2 Likes

Hi @Aluneth_X

Try to change your index 2

cheers :smiley:

Happy learning :smiley:

4 Likes

@Aluneth_X Variable which you displayed in message box Write that variable to text file and check how it’s storing

2 Likes

i changed “\n” into Environment.newline and it works
thank you

3 Likes

@Aluneth_X great you figure it out cheers :smiley:

Happy learning :smiley:

5 Likes

Hi, you can use a PDF Extract too, Here I recommend you the Bitwar program which contains multiple functions, you can just have a try.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.