Ignore single quote while loading text file in to QV?

[#1]

Hi

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

[sunny_talwar]

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

PurgeChar(FieldName, Chr(39)) as FieldName

[settu_periasamy]

Hi,

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

[#4]

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 .

[#5]

Hi

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

[settu_periasamy]

Can you provide samplet text file?