How to extract table from pdf structure format text

[Raja.G (Mr.RPABot)]

Hi Team,

I need to extract table from pdf structure format text , I couldn’t able to pick uppercase name, so please anyone help me on this.

Input:
Abbbcc Yhhhh RAM GANESH N 12345678901 021
ARUN KUMAR R Y 44455566677 980
Rkkll Jkkkiii KAMAL KUMAR S N 55577788814 888

Note:
Number are static digit only
Before 11 digit number mentioned “N” and “Y” not a initial

Output:
Name XX Number code
RAM GANESH 12345678901 021
ARUN KUMAR R 44455566677 980
KAMAL KUMAR S 55577788814 888

Regards,
Raja G

[supermanPunch (Arpan)]

@Raja.G

Abbbcc Yhhhh RAM GANESH N 12345678901 021
ARUN KUMAR R Y 44455566677 980
Rkkll Jkkkiii KAMAL KUMAR S N 55577788814 888

Note:
Number are static digit only
Before 11 digit number mentioned “N” and “Y” not a initial

Hi @Raja.G ,

Could you provide us with a Sample PDF document we can work on or Test our approach with it ?

Also, The Input from Text file has N and Y mentioned but it is not seen in the PDF Table as provided in the image. Are these characters appearing only after Reading the PDF as text ? or is it an Entirely different PDF ?

We would need to get a confirmation on the Pattern of the data in the PDF, so that we can suggest/provide you with a concrete solution.

[sreejith.ss]

Hey @Raja.G please provide the sample input file

Regards

Sreejith S S

[Raja.G (Mr.RPABot)]

Hi @sreejith.ss / @supermanPunch ,

That pdf confidential so couldn’t able to share sorry to this.

Regards,
Raja G

[supermanPunch (Arpan)]

@supermanPunch

Could you provide us with a Sample PDF document

@Raja.G , We did ask for Sample / Similar type of PDF if possible as most of the time the data is confidential.

@supermanPunch

Are these characters appearing only after Reading the PDF as text ?

We would also like to get some clarifications cleared considering the initial 1 letter values mentioned.

[Raja.G (Mr.RPABot)]

Hi @supermanPunch ,

After converting text only its come above format i want string manipulation to split the name only.

Regards,
Raja G

[Raja.G (Mr.RPABot)]

Hi @supermanPunch

How to remove specific text in particular column in cell value

Hi @loveleet_Saini , Thank you for solution , i have another question that string space are longspace i couldn’t get name please help me this. Sorrry to ask again [image] Regards, Raja G

Please help me for this

Regards,
Raja G

[supermanPunch (Arpan)]

@Raja.G ,

Not completely sure if the method provided below would be appropriate as we still do not know the complete pattern of info of the PDF data. But you could try with the following :

Using Regex we could get the Data separated as required :

We could then populate these data into a Datatable.

Check the workflow below and let us know if it satisfies the requirement for other samples of your pdf documents as well.
Regex_Table_Extraction.xaml (9.1 KB)

I have used a text file to read the input data as provided above in your post.

[Raja.G (Mr.RPABot)]

Hi @supermanPunch ,

Yes correct that is long space so please give solution below link,

How to remove specific text in particular column in cell value

Hi @Raja.G Below Solution may help you. [image] FilterCellVAlue.xaml (8.4 KB) o Regards Loveleet Saini

Regards,
Raja G

[supermanPunch (Arpan)]

@Raja.G ,

Is the solution provided by me above not satisfying your required output ?

Could you let us know if Text file / PDF is the input or Excel file is the input ? To avoid confusions, you could send the Input data and the Expected Output Data again.

[Rahul_Unnikrishnan]

Hello @Raja.G

Does that mean while reading the table some unnecessary values are appending and you need to split the text to get the required data? Is this correct or your requirement is something different?

Thanks