Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nakuldev
Creator
Creator

Excel export with comma as delimiter

Hi All,

While exporting to excel from access point, the data results in the fields being separated by a semicolon instead of a comma. It is not possible for us to change the delimiter. Is there a work around to export it properly.

Please find the attachment for reference.

Thank you in advance

Nakul

1 Solution

Accepted Solutions
Vegar
Partner
Partner

I'm sorry about that. The solution provided by the Qlik Support is also making adjustments to  the server defaults.

Knowledge - In QlikView November 2018 Release, Export to Excel CSV Format Results in Fields Being Se...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

5 Replies
Vegar
Partner
Partner

Try this 

STORE table INTO [table.csv](txt, delimiter is ',');

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
nakuldev
Creator
Creator
Author

Hi Vegar,

Thank you for your response but users are exporting data from straight table in access point. 

Thanks 

Nakul

Vegar
Partner
Partner

I haven't tried this my self but according to @duncan_andrew8  post AccessPoint Export to CSV with commas you could handle this by adjusting the regional settings on your windows server. 

 

Hopefully this read will help you!

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
nakuldev
Creator
Creator
Author

Hi Vegar,

I requested/suggested doing changes in the server but admins are not okay with that as it will affect all the documents.

Regards

Nakul

Vegar
Partner
Partner

I'm sorry about that. The solution provided by the Qlik Support is also making adjustments to  the server defaults.

Knowledge - In QlikView November 2018 Release, Export to Excel CSV Format Results in Fields Being Se...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post