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


Text delimiters causing import issue 9 years 9 months ago #2244

  • Ryan Gravlin
  • Ryan Gravlin's Avatar Topic Author
  • Offline
  • Posts: 1
Hello all,

I currently have a tab delimited file that uses single quote (') delimiters. However, not all fields use this text delimiter. If I choose the single quote option in the READ adapter, there are fields that may use a single quote, but only once, which causes FlowHeater to import the rest of the fields into that field.

What I have done is disable the single quote in the READ adapter and I am thinking of using a REPLACE function to get rid of the single quotes in the fields that actually use them as text delimiters.

Is this the right course of action, or maybe there is another way to resolve this problem without having to use functions like that?

Thanks in advance for any help

Ryan Gravlin

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

Re:Text delimiters causing import issue 9 years 9 months ago #2245

Hi Ryan,

With the current Version your solution is the only way to solve this.

But I've thinking about. I guess this case is a common mistake and I've made a quick fix. By following the link (https://flowheater.net/files/FlowHeaterBeta.zip) you can download a BETA version of FlowHeater. Here you have to switch the certain field manually to the FlowHeater data type RAW. In this case only this field is obtain without any further checks. You only have to use the String Replace Heater for the quotes for the certain field.

NOTE: In the BETA version also included 2 new adapters for SQlite and PostgreSQL!
Thanks for this great request.
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.

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

other Languages


FlowHeater Home

de en


Privacy Statement

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

Follow us on

twitter  facebook


 de en