Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

exporting the data from .csv file to database table

hi guys, I need a help in exporting the data from a .csv file to database table. my csv file first row has below format: 

0683p000009M8dr.png

I would like to export the data into table in below format. And how can I remove quotes around the strings.

0683p000009M8c6.png

Labels (3)
1 Reply
talend777
Contributor
Contributor

Have you tried playing with CSV options in tfileinputDelimited ?

By clicking that option it may allow you to select "TEXT Enclosure" in which you can mention " as text enclosure.