CSV file and double quotes

Hi,
 
I am testing your product and I think it could be very useful.  However there is something I have not been able to do which is critical to what I am trying to do. I am trying to use a batch file to append into an access database. That all works well, but I have not been able to remove the double quotes representing a string inside a .csv.  The files are comma delimited but all fields are enclosed between two “.
 
Eg: “Field1”,”Field2”,…….
 
All manualprograms that I use, excel , access , tableau they all strip the “.  Is this possible with your software?
 
 
Thanks
Alfredo (Request reveived via E-Mail)

Hi Alfredo,

Of course You just have to define the needed “Quotation Marks” onto the TextFile Adapter “Delimiter” tab, see screenshot below.

Here you can define a lot of options to configure your needed CSV text delimiter “double quotes”.

Please find attached a brief example.

Configure CSV text delimiter double quotes

Yes, thank you.  It is working.