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