Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Text delimiters causing import issue

Text delimiters causing import issue 4 years 10 months ago #2244

  • Ryan Gravlin
  • Ryan Gravlin's Avatar Topic Author
  • Offline
  • New Member
  • 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

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

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 268
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.
Robert

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

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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.077 seconds