topic Re: JasperETL: File delimited in Talend Studio

JasperETL: File delimited

Anonymous — Sat, 16 Nov 2024 13:30:52 GMT

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

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 03:31:31 GMT

Hello
You need check 'csv' box and set the escape char as """, filed separator as """
Best regards
Shong

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 04:00:28 GMT

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?

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 04:07:34 GMT

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

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 04:27:10 GMT

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

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 04:33:03 GMT

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

Re: JasperETL: File delimited

Anonymous — Wed, 10 Mar 2010 10:16:22 GMT

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