topic Using space and ( in strings in QlikView

Using space and ( in strings

gustavgager — Thu, 15 Aug 2013 09:17:26 GMT

Hi. Im currently creating my first QV app and so far so good. However im now stuck at a very simple but anoying problem.

The apps is currently loading data from CSV files and it all worked fine in my own computer. But when i moved it to our server, it didnt work. Ive narrowed the problem down to the path of the CSV, witch I add do a varible using:
SET path_errorlogs='C:\Program Files (x86)\App\CSV\errorlogs\'; //varible for dir with errorlogs

The varible doesnt get the entire name, only the: "C:\Program Files" path. If i use other paths with space in it, it works. However when i use a path with a space and then (, i get this error. Seems to be aproblem when yo use: " ("

Any idees on how so sort it?

Re: Using space and ( in strings

swuehl — Thu, 15 Aug 2013 09:24:54 GMT

Can't reproduce your issue here. I do get the complete string set into the variable.

On which version of QV are you?

Re: Using space and ( in strings

gustavgager — Thu, 15 Aug 2013 09:27:40 GMT

11.0 SR1 on the server machine (desktop is installed on the server).

Got 11.20 SR2 on my own machine

Re: Using space and ( in strings

swuehl — Thu, 15 Aug 2013 09:31:40 GMT

As a workaround, maybe you can try building your string in parts:

LET path_errorlogs='C:\Program Files ' & ' (x86)\App\CSV\errorlogs\';

LET path_errorlogs='C:\Program Files ' & ' (' & 'x86)\App\CSV\errorlogs\';