topic Re: Section Access Apostrophe Issue in QlikView

Section Access Apostrophe Issue

Tue, 21 Mar 2017 12:56:55 GMT

I'm using Inline statement to give section access put together with USERNTNAME and UserName.
Section_Information:
LOAD * INLINE
[
USERNTNAME,UserName
'NVIN1','VXXX, NXXX'
'HEML1','ZXXX, HYYY'
];

One of the user has an apostrophe in their name, ex: XYZ, D'Costa

So I'm unable to Provide them access as the UserName is not getting picked correclty due to the apostrophe.

Section_Information:
LOAD * INLINE
[
USERNTNAME,UserName
'XYZD','XYZ, D'Costa'
];

I have tried using double quotes but it is not working.
Please help.

Thank you
Atul

Re: Section Access Apostrophe Issue

Anonymous — Tue, 21 Mar 2017 15:56:40 GMT

Try using the apostrophe to the left of the 1 key instead of the usual one

Re: Section Access Apostrophe Issue

Peter_Cammaert — Tue, 21 Mar 2017 16:40:28 GMT

Why are you using quotes anyway in your INLINE load? It's not that spaces are a problem in text strings...

The problem with your weird UserName values (e.g. contain comma's) can be handled by changing the field delimiter character. Like in:

LOAD * INLINE

[

USERNTNAME UserName

XYZD XYZ, D'Costa

] (delimiter is '\t');

There is a TAB character between the field headers and the field values. All quotes have been dropped, except for the one in the name.

Best,

Peter