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:
https://activities.uipath.com/docs/generate-data-table
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 “EdgePDF: online view, edit, markup, redact PDF documents in HTML” 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
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