Can anyone help how to convert pdf tabular data to csv using string manipulations

Anyone help me to convert pdf tabular data to csv using string manipulations

use generate dataTable, where you can convert a string into table and you can write the table to CSV:

Hi @SUPRIYA123,

Can you attach the sample pdf ?

Regards
Balamurugan.S

my problem is that i am getting pdf tabular data in single column at csv file.in between what string manipulations should we use?

can u tell for this?

Hi @SUPRIYA123,

Please open the pdf in this “http://www.rasteredge.com/online/pdf-editor/” and check the content something is wrong.

the real storage content is different. Something manually edited by an image editor. It considers as an image. not a formatted text.

Regards
Balamurugan

ok
delete that images

can u please delete that images from your post .I got it what u said

@SUPRIYA123,

Yes I have deleted it…

ya thanks.

Hi @SUPRIYA123

Please don’t share the confidential things in the form. If you want to share it,send it by message. So it will keep only between the persons.

Regards
Balamurugan.S

ya sure.can u guide me that.If we have columns with student data that needs to be converted to csv file with string manipulations what should we do?

Hi @SUPRIYA123,

Can i take the page 2 as sample data. Because the first one is not well format.

Regards
Balamurugan.S

not that i will send u sample sheet.please tell with that sheet

Ok send it by message.

Regards
Balamurugan

ok.sure

pdf sample2 (1).pdf (12.9 KB)
please guide me for this

can u guide for that table format using string manipulations

Hi @supriya123
What is the static fields and which are the dynamic fields in the pdf ?

all are static