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


#1

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


#2

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


#3

Hi @SUPRIYA123,

Can you attach the sample pdf ?

Regards
Balamurugan.S


#4

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


#5

can u tell for this?


#6

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


#7

ok
delete that images


#8

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


#9

@SUPRIYA123,

Yes I have deleted it…


#10

ya thanks.


#11

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


#12

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?


#13

Hi @SUPRIYA123,

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

Regards
Balamurugan.S


#14

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


#15

Ok send it by message.

Regards
Balamurugan


#16

ok.sure


#17

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


#18

can u guide for that table format using string manipulations


#19

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


#20

all are static