Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
kashjaniqlik
New Contributor III

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
Honored Contributor

Re: Storing data in a text file with ¬ delimiter

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

sdmech81
Valued Contributor

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
New Contributor III

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
Esteemed Contributor II

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

Re: Storing data in a text file with ¬ delimiter

Code page problems, so it seems.

What is the ASCII code of this character?

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