topic Escaping characters in QlikView

Escaping characters

Thu, 11 Nov 2010 11:20:15 GMT

Hey guys,

i want to read all the .txt file from a folders (sub dir included) and i use the following script

sub DoDir (Root)
for each File in filelist (Root&'\*.' &'TXT')
lista_fisiere:
Load
'$(File)' as path
autogenerate 1;

next File
for each Dir in dirlist (Root&'\*' )
call DoDir (Dir)
next Dir

end sub

DoDir(Path);

The script works fine till encounters one folder or txt files which contains quote character ( ' ) in the name.

Anyone know a workaround?

Escaping characters

Thu, 11 Nov 2010 12:12:43 GMT

You could use purgechar function to remove them

purgechar('$File', chr(39))

Regards,

Gordon

Escaping characters

Thu, 11 Nov 2010 12:27:42 GMT

I cant use PurgeChar because based on the name of the file i need to load that folder or not.

Escaping characters

Thu, 11 Nov 2010 13:01:24 GMT

have a batch file that renames the files prior to reload?

-Alex

Escaping characters

Thu, 11 Nov 2010 13:18:44 GMT

not a possible solution because those file are used by other application also

Escaping characters

Mon, 15 Nov 2010 14:26:03 GMT

Hi,

Use nested FOR loops . The quote will get escaped == will appear twice in the loaded field. Works in QV9 64 bits, and QV10 32 bits.



for each Dir in dirlist (Root&'\*' )
 for each File in filelist (Dir &'\*.' &'TXT')
 lista_fisiere:
 Load
 '$(File)' as path
 autogenerate 1;

 txt:
 LOAD @1 as txt
 FROM [$(File)] (txt, codepage is 1252, no labels, delimiter is '\t', msq);

 next
next

-Alex