'Databricks Sql: Alternative to NCHAR() to replace characters

I have names in my table for which I need to replace certain characters with others. I have the following code, but I get an error

REPLACE(REPLACE(TRIM(name),NCHAR(0x2019),NCHAR(0x0027)),NCHAR(0x200B),'')

However I get the following error message. Can somebody help me rewrite the code not using the Nchar function?

Undefined function: 'NCHAR'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'

sqlapache-spark-sqldatabricksdatabricks-sql


Solution 1:[1]

Instead of NCHAR function you can use unicode literals (\uXXXX) to represent a character as it's described in Spark documentation, in your case it will be:

REPLACE(REPLACE(TRIM(name),'\u2019','\u0027'),'\u200B','')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Alex Ott

Related Questions