Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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