Ignore single quote while loading text file in to QV?
I have a text file which have single quotes in text field values. while loading that text file because of the single quote field value is distributed to other fields and causing data mismatch. Can anyone suggest how to ignore single quotes while loadint text fiel in to qlikview. I tried using different delimiters but still the issue is not solved.
Re: Ignore single quote while loading text file in to QV?
I think we can use purge char or replace functions on feilds but not on entire table while loading. I want ignore single quotes completely while loading text file into qlikview. My table contains more than 80 felids and in future we are nto sure which field will have single quotes.