In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to remove?

rmartinez4
8 - Asteroid

Hi,

 

I want to remove this square from this column. I do have other data formatted this way in this column (DFRSSETD123, 192.000.121.1, etc) but I can't seem to remove this character.

 

rmartinez4_0-1661355168710.png

 

5 REPLIES 5
binuacs
21 - Polaris

@rmartinez4 try the TrimLeft(String,y) function where you need to specify the character you wanted to remove in place of y 

 

binuacs_0-1661355688721.png

 

rmartinez4
8 - Asteroid

Odd. The squared in front does not show up as a character.

Robin_McIntosh
11 - Bolide

Try a REGEX tool like this.

 

Robin_McIntosh_1-1661356664530.png

 

rmartinez4
8 - Asteroid

You're Magical 

Robin_McIntosh
11 - Bolide

@rmartinez4 Also removes the pesky black diamond with question mark if you ever get them.

 

Robin_McIntosh_0-1661357432277.png

 

Labels
Top Solution Authors