I would like to remove MRN leading zeros. sometimes there are 1 zero and sometimes there are 3 or 4.. which function should i use to to remove the leading zeros? any suggestions? thanks!!!
The simplest would probably be the string command. There is called “trimleft” where you can specify a character or number to trim from the left (leading) side of a variable.