Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

CSV file and double quotes

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 1 month ago #3603 by FlowHeater-Team
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)

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 to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 1 month ago #3604 by FlowHeater-Team
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 AdapterDelimiter” 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.
Attachments:

Please Log in to join the conversation.

More
3 years 1 month 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 to join the conversation.

Time to create page: 0.333 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.