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
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?
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
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
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
