I want to cut out the first letter.

[Paknanarn23]

If the first one is Z, cut it out, but if the first one is any other, keep it. What should I do?

[MayilVahanan · Accepted solution]

Hi

Try like below

If(Left(Urfield,1)  <> 'Z', Urfield)

[Hania]

Hello @Paknanarn23 ,

if you want to remove all 'Z' from your column so ,

I think  you can try it in your script.

PurgeChar("Field Name ", 'Z') 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Lisa_P]

Use this logic ..

IF(DCE_KCEPart1 like 'Z*', Right(DCE_KCEPart1, 11), DCE_KCEPart1)