Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Noobforever
Contributor
Contributor
‎2022-12-01 07:34 AM

Fast export straight table CSV giving special characters

Hi, I have a pivot table and for some of the measures I have used repeat(char(160),5) to give some space but when I Fast export straight table CSV it gives special characters     Â. What can I do to aviod this.

Labels (1)
Labels

  • Chart

409 Views
0 Likes
3 Replies
marcus_sommer
MVP
MVP
‎2022-12-01 08:36 AM

Open the csv with an editor like Notepad++ to see which data are really there. Tools like Excel have often very own ideas how to interpret any content ...

- Marcus

387 Views
0 Likes
Noobforever
Contributor
Contributor
‎2022-12-02 01:09 AM
Author

In response to marcus_sommer

Its a organization laptop I cannot do that.

370 Views
0 Likes
marcus_sommer
MVP
MVP
‎2022-12-02 01:37 AM

In response to Noobforever

An extra installation with admin-rights is usually not needed because often there are such tools already installed or they could be taken from a company-portal (it's quite common within larger companies).

If this is really not possible you may just take the default Windows-editor Notepad which would already provide valuable hints and further you may copy & paste the appropriate parts into an Excel cell and using the inbuilt Excel functions to check the lengths or the char-index and so on. Also possible should be to use a web-service to investigate the content.

- Marcus

367 Views
0 Likes