Conditionally remove first character from string

[robin_heijt]

Hi,

I have a bunch of Unique ID's, but for some reason my source system adds a 0 to the beginning of the string if the string is shorter than 7 numbers.

How can I write a condition for; If first character is 0, then delete first character?

Thanks

[sunny_talwar]

May be like this

If(Left(StringField, 1) = 0, Mid(StringField, 2), StringField)

[pradosh_thakur]

Mid(Your_field,2)

if(left(your_field,1)=0,mid(your_field,2),your_field)

edited.