Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
naddasandeep
Contributor III
Contributor III

Creating a Customized Delimiter in Qlikview

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

Labels (2)
1 Solution

Accepted Solutions
FakeJupiter
Creator
Creator

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

View solution in original post

4 Replies
QFabian
Specialist III
Specialist III

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

 

 

 

QFabian
naddasandeep
Contributor III
Contributor III
Author

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
Creator
Creator

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
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.