Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Ignore single quote while loading text file in to QV?

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

5 Replies
sunny_talwar
Not applicable

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

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

PurgeChar(FieldName, Chr(39)) as FieldName

settu_periasamy
Not applicable

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

Hi,

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

Capture.JPG

Not applicable

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.

anyways thanks for your reply Sunny .

Not applicable

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

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
Not applicable

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

Can you provide samplet text file?