Delete two letters at the front

[rafatomillero]

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?

[DataNath · Accepted solution]

@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:

[Emmanuel_G]

@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.

[rafatomillero]

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

[Emmanuel_G]

@rafatomillero  

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