Parsing Data - problems with variables

Anonymous — Tue, 23 Nov 2010 01:24:46 GMT

I have a big text file with configuration data that i need to parse. I can read it into one attribute in a table in QV ( configdata ). I can also then display the contents of this attribute in a text box. I can apply string functions to the text and the results are what I would expect. My issue is that when i try and use these same string functions in the script as i start to parse the data, i get <NULL> as a result (or lack thereof lol).

Here's the script.

LOAD @1:n as configdata
FROM
E:\Projects\Pepsi\configdata\DashboardProperties.cfg
(fix, codepage is 1252, record is 32767 lines, no eof);

let logins = textbetween(configdata,'[Supervisors]','[');
let loginsnum = substringcount(logins,'=');
let teststring = left(configdata, 50);

Here's the readout from debug stepping through script.

teststring <NULL>
configdata <NULL>
logins <NULL>
loginsnum <NULL>

Just want to say again that the above 3 statements work fine in a textbox after the script has run. Runtime, no dice. Any ideas?

Parsing Data - problems with variables

Anonymous — Tue, 23 Nov 2010 01:32:25 GMT

Oop. Accidently deleted my peek. All good now...

LOAD @1:n as configdata
FROM
E:\Projects\Pepsi\configdata\DashboardProperties.cfg
(fix, codepage is 1252, record is 32767 lines, no eof);

let condata = peek('configdata',0);
let logins = textbetween(condata,'[Supervisors]','[');
let loginsnum = substringcount(logins,'=');

let teststring = left(condata, 50);

topic Parsing Data - problems with variables in QlikView

Parsing Data - problems with variables

Parsing Data - problems with variables