Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Edit Module - Export to CSV - Commas in field value

Hi everyone,

I have a macro:

Sub ExportToCSV

set sObject = ActiveDocument.GetSheetObject("TB01")

sObject.Export "C:\Test.csv", ", "

End Sub

However, I have a field FullName, which has values of the format LastName, FirstName.

When I run this macro, LastName and FirstName incorrectly get split into two columns because of the comma.  Is there any way to qualify these cell values so it stays in 1 cell, somehow?

1 Reply
MVP & Luminary
MVP & Luminary

Re: Edit Module - Export to CSV - Commas in field value

Specify a different separator, for example a semicolon: sObject.Export "C:\Test.csv", "; "

Or replace the comma's in the FullName field with something else.

talk is cheap, supply exceeds demand