Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If the first one is Z, cut it out, but if the first one is any other, keep it. What should I do?
Hi
Try like below
If(Left(Urfield,1) <> 'Z', Urfield)
Hi
Try like below
If(Left(Urfield,1) <> 'Z', Urfield)
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!
Use this logic ..
IF(DCE_KCEPart1 like 'Z*', Right(DCE_KCEPart1, 11), DCE_KCEPart1)