Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

gustavgager
Contributor II

Using space and ( in strings

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?

3 Replies
MVP
MVP

Re: Using space and ( in strings

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

On which version of QV are you?

gustavgager
Contributor II

Re: Using space and ( in strings

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

Got 11.20 SR2 on my own machine

MVP
MVP

Re: Using space and ( in strings

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

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

or

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

Community Browser