Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
bobbyn4u
New Contributor III

Special characters problem from googlesheet data

Hello All,

I have a data in google sheets and it is connected to Qliksense using connectors. There are few special characters in the data like Börse and getting the data in Qliksense as  B~A?se .  Kindly help me out how to handle this kind of data loading from google sheets.


output should be:


Börse

1 Solution

Accepted Solutions
Employee
Employee

Re: Special characters problem from googlesheet data

Hi,

I'm not sure which version of the Qlik Web Connectors you are using, but could you please try the latest version (November 2017, Patch 2) because an issue with character encoding for Google Spreadsheets was fixed in a patch earlier this year (Patch for Qlik Web Connectors November 2017 Release Available).

If you still have issues with the latest version, please let me know.

Thanks!

View solution in original post

16 Replies
mayankraoka
Valued Contributor

Re: Special characters problem from googlesheet data

Hi,

Try this:

LOAD

    Text(YouField) as YourField,

     ...

FROM ...;

Which version of qliksense you are using?

Regards,

Mayank

Chanty4u
Esteemed Contributor III

Re: Special characters problem from googlesheet data

if you know  characters

you can use

purgechar(field,'~!@#$%^&*()_+')    as Yourfield

bobbyn4u
New Contributor III

Re: Special characters problem from googlesheet data

Hi,

Text function is not working.

Version - 12.5.2

mayankraoka
Valued Contributor

Re: Special characters problem from googlesheet data

so if you know the characters you can try what Chanty said Keepchar fucntion like this

keepchar(field,'~!@#$%^&*()_+')    as Yourfield


Regards,

Mayank

bobbyn4u
New Contributor III

Re: Special characters problem from googlesheet data

How to put ö char into the list.  Any idea?

Regards,

Lakshminarayana

mayankraoka
Valued Contributor

Re: Special characters problem from googlesheet data

you can take from character map .Attached screenshot.

Regards,

mayank !

Re: Special characters problem from googlesheet data

Most likely, you need to configure the connector to use Unicode / UTF8 instead of codepage 1252.

bobbyn4u
New Contributor III

Re: Special characters problem from googlesheet data

Thank you, Mayank. I tried the keep char function, I am getting the blank data in that field. Kindly check the below function and let me know the solution.

keepChar([Global Customer Name], 'Ö') as [Global_Customer_Names]

mayankraoka
Valued Contributor

Re: Special characters problem from googlesheet data

Ideally you should not get blank,

try this,

keepChar([Global Customer Name],'ö') as [Global_Customer_Names]


Regards,

Mayank