Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
17 - Castor

@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