How to export a string field containing commas and not split the field into separate colomns .csv

lmcarter — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community 🙂

I have a dashboard where a user needs to:

Apply certain filters/selections
Type a unique message for 3 groups in a table
Click an 'export' button to export a .csv file that contains all selections made as well as the text of the messages they typed into the table

To create the table with input functionality I did the following:

INPUTFIELD [message];

TableName:
LOAD * INLINE [
Message
'Group1 Message'
'Group2 Message'
'Group3 Message'
];
Left Join (TableName)
Load *,
'' As [message]
Resident TableName;

Store TableName Into TableName.qvx;

My problem is when a user tries to export a .csv where the message text they typed contains commas. The exported .csv file then splits the message text at every comma and creates multiple fields (ie: if the message contains 3 commas then the .csv file creates 3 separate message input text's)

Is there any way to solve this without exporting the file as a .txt and keeping it as a .csv?

Many thanks!

Re: How to export a string field containing commas and not split the field into separate colomns .cs

zhadrakas — Thu, 25 Apr 2019 13:16:56 GMT

If your fields contains values with a comma (your number-delimiter for thousands) you could not use comma as delimiter for the csv. Change this to semicolon or tab or change your number-format.

regards
tim

topic Re: How to export a string field containing commas and not split the field into separate colomns .cs in QlikView

How to export a string field containing commas and not split the field into separate colomns .csv

Re: How to export a string field containing commas and not split the field into separate colomns .cs