FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
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
  • Page:
  • 1

TOPIC:

CSV file and double quotes 3 months 3 days ago #3603

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 366
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 3 months 3 days ago #3604

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 366
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 or Create an account to join the conversation.

CSV file and double quotes 3 months 2 days ago #3605

Yes, thank you.  It is working.

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

  • Page:
  • 1
Time to create page: 0.205 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en