Dynamic data import / export

simply more productive
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Text delimiters causing import issue

Text delimiters causing import issue 4 years 1 month ago #2244

  • Ryan Gravlin
  • Ryan Gravlin's Avatar
  • Offline
  • New Member
  • 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
The administrator has disabled public write access.

Re:Text delimiters causing import issue 4 years 1 month ago #2245

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 233
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.071 seconds