shieldsco
asked on
Access String
I'm using the folling code to replace zero after only the first occurance of a dash:
Replace([FieldName],"-0"," -",1 ,1)
However the codes does not work in all cases. For Example:
75-01-0140 Before
75-1-0140 After - Ok
75-10-0140 Before
75-10-140 Incorrect -- Only if zero after the first dash other wise do nothing
75-10-0140 After - Ok
Replace([FieldName],"-0","
However the codes does not work in all cases. For Example:
75-01-0140 Before
75-1-0140 After - Ok
75-10-0140 Before
75-10-140 Incorrect -- Only if zero after the first dash other wise do nothing
75-10-0140 After - Ok
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Open in new window
You can call it from a query as follows:
Open in new window