Hi Team,
Could you please help me to get the desired output
whenever the last letter in the input is alphabet I would like to replace it with zero
Many Thanks in advance!!
Input | Output |
A1234D | A12340 |
B1968A | B19680 |
C0659E | C06590 |
D0874d | D08740 |
E02540 | E02540 |
Solved! Go to Solution.
@sneha_bhiwagade1 one way of doing this
Try this in a Formula tool:
IF Uppercase(Right([Original value], 1)) >= "A" and
Uppercase(Right([Original value], 1)) <= "Z"
THEN
Substring([Original value],0,Length([Original value]) - 1) + "0"
ELSE [Original value]
ENDIF
Check out all functions here: https://help.alteryx.com/current/en/designer/functions.html
Chris
Thank You @binuacs