How to add leading zeros to split field string

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

How do I add leading zeros to this?

BLDG: Mid([LOCATION],InStr([LOCATION],"-")+1)

Please help.
 
My response yesterday --
Left([YourField], InStr([YourField], "-")-1) & Right("00000" &
Mid([YourField], InStr([YourField], "-")+1, 5)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add leading zeros and possibly undo 5
leading zeros 6
Database syntax error 2
Split data in field on character return 0
Dropping Leading Zero 3
Length of Text 2
Leading zero in time 4
Leading Zero 11

Back
Top