Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CSV file with "comma seperator"

  hi all,

my macro query is given below

Sub CSV
set sObject=ActiveDocument
set b=sObject.GetSheetObject("CH02")

b.Export "D:\Qlikview\filename.csv",";"

End Sub

this query send my CSV file with ";" delimter but i want it in "," delimiter.

IF I CHANGED MY QUERY LIK THIS

Sub CSV
set sObject=ActiveDocument
set b=sObject.GetSheetObject("CH02")

b.Export "D:\Qlikview\filename.csv",","

End Sub 

then my output looks like excel no delimiters.

How i will get comma delimiter for this any idea?

thx

1 Reply
swuehl
MVP
MVP

b.Export "D:\Qlikview\filename.csv",","

works for me. I do get a comma separator.