JasperETL: File delimited

One Star

JasperETL: File delimited

Hi!
I have a csv file with field delimiter and text delimiter as follow:
"Alan Tan", "Specialist", "35", "67%"
I would like to use JasperETL to import the data to database. However because of the double quotation mark text delimiter, JasperETL copied the whole "35" to database therefore my db doesnt understand 35 as a number. Is there any way to remove the quotation mark and make JasperETL copy 35 to db as an int number ?
Thanks
Community Manager

Re: JasperETL: File delimited

Hello
You need check 'csv' box and set the escape char as """, filed separator as """
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: JasperETL: File delimited

Hi Shong!
I did as you said but it doesnt work. I tried 4 cases:
1/ Set Escape char and Text enclosure with """
2/ Escape char: Empty, Text enclosure """
3/ Escape char: """, Text enclosure: Empty
4/ Escape char and Text enclosure: Empty
All didnt work when I clicked on Refresh preview and run to export to db either.
Do I need to do any more step?
Community Manager

Re: JasperETL: File delimited

Hello
Which version do you use? Java or Perl project?
I am working on TOS3.2.3 with java project, and it works fine.(see my screenshot)
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: JasperETL: File delimited

Hi Shong,
When I choose "\"" for both Escape Char and Text Enclosure as shown in your attachment and click preview, the preview table appear without quotation mark just like in your attachment pic but when I run job with input: tFileInputDelimited and output: tMysqlOutput, the output to my db still have quotation mark.
Do you have any idea? I use 3.2.1
Thanks
Community Manager

Re: JasperETL: File delimited

Hello
Before inserting into db, use a tLogRow to print the result on concole and see if it read correctly. You can aslo try other version of TOS.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: JasperETL: File delimited

Hi!
I tried with JasperETL 3.2.3 and it works fine now. Thankss