Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kashjaniqlik
Not applicable

Storing data in a text file with ¬ delimiter

Hello

I'm storing some data from a QVD in to a text file with ¬ delimiter. When opening the file in a notepad, it comes out as a different character - as shown in attached file.

Trying a few other delimiters works fine i.e they are output in the text file as they are specified in the QV code.

Any thoughts will be much appreciated.

Thanks

6 Replies
ahaahaaha
Not applicable

Re: Storing data in a text file with ¬ delimiter

Can you change the separator in the QVD file, in principle?

sdmech81
Not applicable

Re: Storing data in a text file with ¬ delimiter

Plss send qvd/qvw here..If nt full at least some data of 5-10 rows..

kashjaniqlik
Not applicable

Re: Storing data in a text file with ¬ delimiter

Hello

We'd like the separator in the text file when we output the file rather than in the QVD

vinieme12
Not applicable

Re: Storing data in a text file with ¬ delimiter

there is a predefined list of custom delimiters that you can use but '¬' is not one of them

On the data load wizard, select Delimiter dropdown and select Custom to see list of available delimiters that you can use

Peter_Cammaert
Not applicable

Re: Storing data in a text file with ¬ delimiter

Code page problems, so it seems.

What is the ASCII code of this character?

Peter_Cammaert
Not applicable

Re: Storing data in a text file with ¬ delimiter

Have you seen this?

Special Delimiter 172.jpg

The text between parentheses should provide you with a clue...

Best,

Peter