Insert Special characters in a formula using codes?

Hi Everyone,

I am trying to insert special characters into a formula using Unicode..

In Excel, I would use something like so:

SUBSTITUTE([cell],CHAR(160)," ")

In Alteryx, I want to do something similar but instead of using: Replace([cell], " ", " ") , I want to use the codes found here: https://en.wikipedia.org/wiki/List_of_Unicode_characters

Anyone has any guidance on how to achieve this?

Thank you.

Parse

Accepted answers

atcodedog05

Hi @E4Victory

You can try CharFromInt() function which turns Unicode number to character. Using this you can replace. Guessing its similar to Char function.

And vise versa is CharToInt()

Hope this helps 🙂

charfromint.yxmd

All comments

dougperez

Thats a tricky one hahaha, i dont know if the replace formula do that

Try to use Regex to do this or create a table with the code/specialcharacters and use the find/replace.

mceleavey

Hi @E4Victory ,

I've attached a tool that allows you to pull tables from HTML. Use this to load in that table, then use a find and replace tool to replace with the unicode characters.