topic Re: Ignore single quote while loading text file in to QV? in QlikView

Ignore single quote while loading text file in to QV?

Tue, 12 Apr 2016 18:22:27 GMT

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.

Thank you in Advance !!

Regards.

Krish

Re: Ignore single quote while loading text file in to QV?

sunny_talwar — Tue, 12 Apr 2016 19:08:44 GMT

Can you share a sample of how it looks? May be you can use PurgeChar()

PurgeChar(FieldName, Chr(39)) as FieldName

Re: Ignore single quote while loading text file in to QV?

settu_periasamy — Wed, 13 Apr 2016 03:19:32 GMT

Hi,

Have you tried with 'Quoting' option in the Wizard?

Re: Ignore single quote while loading text file in to QV?

Wed, 13 Apr 2016 17:14:54 GMT

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.

anyways thanks for your reply Sunny .

Re: Ignore single quote while loading text file in to QV?

Wed, 13 Apr 2016 17:16:02 GMT

I tried quoting option , it worked but not hoe I expected but my problem loading from text file to qlikview is sloved with that.

Thankyou

Re: Ignore single quote while loading text file in to QV?

settu_periasamy — Wed, 13 Apr 2016 17:47:04 GMT

Can you provide samplet text file?