On Fri, 25 Jul 2008 06:41:57 -0700 (PDT), DanCole42
<dancole42@gmail.comwrote:
First off you need a text field.
Then make the first pass and strip off anything starting with "-". You
could do that with a combination of Left$ and InStr.
Then make a second pass and add leading zeros. You could do that with
Format or with Len.
Give it a try.
-Tom.
Microsoft Access MVP
Quote:
>Newbie question, here.
>
>I have a database that frequently imports ZIP code data that
>frequently needs cleaning:
>
>12365
>6487
>64684-3543
>3213-6546
>
>
>I.e. missing leading zeroes, five digit vs nine digit ZIPs, etc.
>
>How would I format the "Update To" command to: 1) restore leading
>zeroes to four and eight digit zips and 2) standardize all ZIPs to
>five digits??
>
>Thanks!
