Creating a Customized Delimiter in Qlikview

[naddasandeep]

Hi Team,

How can we create a customized Delimiter in qlikveiw like if I want to use Double Dagger( ‡) as a delimiter while creating the QVD how can we use it?

I tried it using its chr() value/Passing Variable as Delimiter but its not working. 

Any help will be great!!

Thanks

Sandeep

[QFabian]

Hi, the thing is that QVD store fields directly, no need of delimiter definition.

Delimiters can be choose when yo load data from text files, and those files,could have ny delimiter as you want, or the system allows.

Here a example script loading a text file with  comma delimiter:

LOAD
"Month",
Value as [Input Data Sales]
FROM [lib://Datos (fabian_fabian)/simple.txt]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

[naddasandeep]

Hi,

I know the qvd creation process, if instead of creating qvd if I need to create a txt file with the delimiter as double dagger then how we can implement that?

[FakeJupiter · Accepted solution]

I understand you are using Store function to export a text file?

If so, just define the delimiter whatever you want it to be, for instance like this:

Store Table1 into Table1.txt ( txt, delimiter is '‡');

[Brett_Bleess]

Just wanted to add the Help Doc reference which does say a delimiter can be specified, so the above post should do the trick I believe.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

I am going to see if doc team can add a sample to show that though as there is not one currently.

Regards,
Brett