TOPIC:

CSV file and double quotes 1 year 3 months ago #3603

FlowHeater-Team
Topic Author
Offline
Posts: 391

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)

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

CSV file and double quotes 1 year 3 months ago #3604

FlowHeater-Team
Topic Author
Offline
Posts: 391

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

File Attachment:

File Name: csv-double-quotes.zip
File Size:31 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.