See also the existing examples of using the
TextFile Adapter
, which may answer your question: text file codepage converting
1
/
2
,
processing of CSV header and footer rows
,
Import/Export vCard (line based) text files
CSV file and double quotes
- FlowHeater-Team
-
Topic Author
- Offline
- Administrator
-
Less
More
1 year 11 months ago #3603
by FlowHeater-Team
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.
CSV file and double quotes was created by FlowHeater-Team
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)
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.
- FlowHeater-Team
-
Topic Author
- Offline
- Administrator
-
1 year 11 months ago #3604
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic CSV file and double quotes
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
Of course

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
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.
- Alfredo Vincenty
- Offline
- New Member
-
Less
More
1 year 11 months ago #3605
by Alfredo Vincenty
Replied by Alfredo Vincenty on topic CSV file and double quotes
Yes, thank you. It is working.
Please Log in or Create an account to join the conversation.
Time to create page: 0.359 seconds