topic Re: Creating a Customized Delimiter in Qlikview in QlikView

Creating a Customized Delimiter in Qlikview

naddasandeep — Sat, 16 Nov 2024 18:00:22 GMT

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

Re: Creating a Customized Delimiter in Qlikview

QFabian — Wed, 07 Oct 2020 14:52:41 GMT

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);

Re: Creating a Customized Delimiter in Qlikview

naddasandeep — Wed, 07 Oct 2020 15:39:23 GMT

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?

Re: Creating a Customized Delimiter in Qlikview

FakeJupiter — Thu, 08 Oct 2020 11:51:20 GMT

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 '‡');

Re: Creating a Customized Delimiter in Qlikview

Brett_Bleess — Thu, 22 Oct 2020 19:14:22 GMT

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/ScriptRegularStatements/Store.htm

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

Regards,
Brett