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?
Solved! Go to 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:
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.
Excellent! @DataNath thanks for your reply, simple and efficient.
You can use Trim([Field],"") or Replace([Field]," ","") or cleansing tool and select remove all whitespaces