Identify last letter is string or number

[sneha_bhiwagade1]

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

[binuacs · Accepted solution]

@sneha_bhiwagade1 one way of doing this

[ChrisTX · Accepted solution]

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

[NidhiSethi · Accepted solution]

A sample way to achieve the output. 

[sneha_bhiwagade1]

Thank You @binuacs