Can someone write an expression for me that removes preceeding 0's from a column? The column has a mix of Numbers and Text so changing the field type isn't an option!
For instance.....
Transform this:
0045676
068
00356796
045678
V45678
Into this:
45676
68
356796
45678
V45678
Thanks in advance!
TheRat
For instance.....
Transform this:
0045676
068
00356796
045678
V45678
Into this:
45676
68
356796
45678
V45678
Thanks in advance!
TheRat