Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
If(Left(StringField, 1) = 0, Mid(StringField, 2), StringField)
Mid(Your_field,2)
if(left(your_field,1)=0,mid(your_field,2),your_field)
edited.