Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon everyone,
I'm currently stuck on an issue with some data within a field in one of my tables. The field is named INDXFLD and is currently formatted to look like this:
The issue I have is I need to reformat it so the 'F' is at the beginning and the preceeding zero's are removed, it should end up looking like this:
Can anyone help me please, the number of zero's can change but it will always start with the first digit which isn't a zero.
Thanks is advance.
something like this maybe: right('000047398F',1)&num(left('000047398F',9),'0')
something like this maybe: right('000047398F',1)&num(left('000047398F',9),'0')
it can be something like this ...
=right('000047398F',1)&''&num(left('000047398F',9))
^5 Gysbert
Excellent, thanks chaps...I appreciate the irony of two separate answers being the same!!