Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

thomaswrieck
Contributor

put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

Hi,

what I would like to achive is to fill a variable with (txt, utf8, embedded labels, delimiter is '\t', msq).

I have problems to keep the ' around \t . Does somebody know a solution for that ? I've already tried the following but this doesn't work. Also experimenting with chr(39) doesn't work ...

LET vConf_FormOpt='(txt, utf8, embedded labels, delimiter is ' & '\t' &' , msq)';

Thanks

Thomas

Tags (2)
6 Replies
Highlighted

put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

Hello Thomas,

Use SET instead, since you don't want to store any evaluated formula (actually you want to keep the string as it is):

SET vTxtOptions = (txt, codepage is 1252, embedded labels, delimiter is ';', msq); LOAD id, name FROMC:\file.csv$(vTxtOptions);


Hope this helps

gandalfgray
Valued Contributor II

SV:put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t


Let vConf_FormOpt = '(utf8, txt, delimiter is ' & Chr(39) & '\t' & Chr(39) & ', embedded labels, msq)';

hope this helps

thomaswrieck
Contributor

put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

Hi Miguel,

thanks for looking into this ... but this doesn't work either ...

regards

Thomas

put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

Thomas,

is working fine here, what error are you getting?

thomaswrieck
Contributor

put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

Hi,

the following works :

SET vTxtOptions = (txt, utf8, embedded labels, delimiter is ',', msq);

$(vConf_GenType)_All_Facts:

LOAD

%Server,

ServerName,

ServerApplication,

ServerOS,

ServerOSType,

ServerDomain,

ServerImportanceLevel,

§F_IsWin,

§F_IsUnX,

ServerOSVersion,

ServerDescription,

ServerStatusInfo,

ServerLastCriticalEvent,

ServerNextEvent

FROM $(vConf_SourcePath)\$(vConf_GenType)_D_Server_update.$(vConf_GenType)

$(vTxtOptions);



While working on that I was checking the content of the variable via a textbox and withing this it wasn't displayed correctly. When checking the variable list in the client teh string was correctly set and is also working withing the script.

Thanks a lot !

Thomas

lcarlos_pe
New Contributor III

Re: put (txt, utf8, embedded labels, delimiter is '\t', msq) into a variable keeping ' around \t

I try the solution apointed by Miguel Angel and it works.

set v_tipo_arq_csv = (txt, utf8, embedded labels, delimiter is ',', msq);