Special characters problem from googlesheet data

[bobbyn4u]

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

[mayankraoka]

Hi,

Try this:

LOAD

    Text(YouField) as YourField,

     ...

FROM ...;

Which version of qliksense you are using?

Regards,

Mayank

[Chanty4u]

if you know  characters

you can use

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

[bobbyn4u]

Hi,

Text function is not working.

Version - 12.5.2

[mayankraoka]

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

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

Regards,

Mayank

[bobbyn4u]

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

Regards,

Lakshminarayana

[mayankraoka]

you can take from character map .Attached screenshot.

Regards,

mayank !

[hic]

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

[bobbyn4u]

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]

Ideally you should not get blank,

try this,

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

Regards,

Mayank