Special Characters in Address Search

[Former Member]

Hi All ,

I am facing a strange issue , during Address Cleanse Transformation , I am getting characters like 'ß' in some Address Suggestion fields . I need to remove these characters .

Database is UTF-8

[paul_kessler · Accepted solution]

You do not provide much detail. Are these German addresses? If so, the character 'ß' may be valid. For example, in German addresses, the word for street is 'strasse' or 'staße'.

If these are random characters embedded in the text then they may represent unprintable characters in your source data. You can fix the source, or you can use search_replace() or replace_substr() function to remove the characters after address cleanse.

Paul

[Former Member · Accepted solution]

Thats correct Paul.These are in infact german addresses. I would like betas to be replaced by ss. I tried the following code as well.

search_replace([], , , [],

,

[]) SET (

"internal_table" = '',

"run_as_separate_process"='no')

But this doesn't seem to worl.Also It changes the ß back to ? everytime i relogin so it becomes

search_replace([], , , [],

,

[]) SET (

"internal_table" = '',

"run_as_separate_process"='no')

Any suggestions?

[paula_augedahl · Accepted solution]

Hi,

This may or may not be helpful, but it's something you can check.

I have seen this type of conversion to a ? mark in the past when using Custom Functions that had characters that weren't understood by the local repository's code page setting. The information for the function was stored in the local repository and until that database was set to properly interpret the character that was converted to a ?, they saw problems like this.

I would suggest contacting your database admin to set the local repository's code page/characterset to handle the character you are trying to enter and save.

Thanks,

Paula

[Former Member · Accepted solution]

Instead of using the character ß, can you try with ascii code? I hope it is 225.

can you try

replace_substr(Input_Col,chr(225),'ss')

Regards,

Suneer

[Former Member · Accepted solution]

Doesn't work

[Former Member · Accepted solution]

Please try this also.

replace_substr(Input_Column,chr(223),'ss')

Regards,

Suneer