Trim help

[rmartinez4]

 Hi is it possible to share how to remove the white squared using Alteryx.

test1-day1    Result should be test1-day1.

Thank You,

[JosephSerpis]

Hi @rmartinez4 you can use the formula Trim within a formula tool to remove white space.

[rmartinez4]

The cleansing tool is not removing the  character in front of test1.

[CharlieS · Accepted solution]

A powerful way to remove non-standard characters (which sometimes display as white squares) is to convert the string field using a code page of standardized characters. The expression looks like this:

ConvertToCodePage([Field1],65001)

This will take those characters in the field specified ([Field1[ in the example above) and convert it to only characters found in the code page that you identify using the ID for that code page. A common example is UTF-8 which is identified with the ID 65001. For a list of other code pages, check out the documentation here:
https://help.alteryx.com/20221/designer/code-pages

Let us know if this works for you or we should explore other options.