Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community 🙂
I have a dashboard where a user needs to:
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!