Discussion Board for collaboration on QlikView Scripting.
I have a macro:
set sObject = ActiveDocument.GetSheetObject("TB01")
sObject.Export "C:\Test.csv", ", "
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?
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.