Edit Module - Export to CSV - Commas in field value

Wed, 12 Jun 2013 16:49:49 GMT

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?

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

Gysbert_Wassenaar — Thu, 13 Jun 2013 11:39:12 GMT

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.

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

Edit Module - Export to CSV - Commas in field value

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