Text delimiters causing import issue

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

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