Identify last letter is string or number

Question

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!!

InputOutputA1234DA12340B1968AB19680C0659EC06590D0874dD08740E02540E02540

binu_acs · Accepted Answer

@sneha_bhiwagade1 one way of doing this

ChrisTX · Accepted Answer

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 Answer

A sample way to achieve the output.