Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Delete two letters at the front

rafatomillero
7 - Meteor

I have a column with different values, and not all of them of the same length e.g.: HJ334XT35, or PN38R3 and I want to delete the two letters at the front for all of them, so it will become 34234GF335 and 38R3. How do I achieve this?

4 REPLIES 4
DataNath
16 - Nebula

@rafatomillero I'd use something like the Right() function for this, combined with a Length() function so that Alteryx only takes everything to the right of the first 2 characters:

 

DataNath_0-1663922972932.png

Emmanuel_G
13 - Pulsar

@rafatomillero 

 

Find attached two ways of doing that.

 

Let me know if there is any issue.

 

Please do not hesitate to mark this answer as solution if it helped.

 

Emmanuel_G_0-1663923171980.png

 

rafatomillero
7 - Meteor

Excellent! @DataNath thanks for your reply, simple and efficient.

Emmanuel_G
13 - Pulsar

@rafatomillero  

 

You can use Trim([Field],"") or Replace([Field]," ","") or cleansing tool and select remove all whitespaces

Labels