Still have Issues with leading zeros after applying switches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zachary - 06 Feb 2005 21:47 GMT

I am experiencing the exact same situation as Richard originally wrote on
2/4/05. When merging zip codes, leading zero is dropped on 5 digit zip code;
10 digit with leading zero works fine.
Additional background-
1. My data source is provided in html format.
2. In data source, zip codes can be either be 5 digit or 10 digit (9 digit
plus the '-' in between zip and 4 ext. The '-' cannot be easily removed)

Went to gmayor.com as suggested in several postings. The \# "00000" switch
works great if the data source has 5 digit zip codes only. In my case, If a
10 digit zip is passed in, then the formatting treat it like a subtraction
calculation. So 12345-6789 ends up as '05556' and 01234-5678 ends up as
'-04444'

I tried different variations on the swith syntax with no luck. Any
suggestions would be greatly appreciated!

Signature

Zachary

Reply to this Message

Terry - 06 Feb 2005 22:22 GMT

Zachary,

I always treat zip codes (called postcodes here) as text
and store them in a text field. We use 4 digit zip codes
and after importing, query the input field with a len
([postcode]) and a criteria of <4. Base an update query on
this and update to "0"&[postcode]. Run the update query
until no more rows need updating.

HTH,

Terry

>-----Original Message-----
>I am experiencing the exact same situation as Richard originally wrote on
[quoted text clipped - 13 lines]
>I tried different variations on the swith syntax with no luck. Any
>suggestions would be greatly appreciated!

Reply to this Message

Terry - 06 Feb 2005 22:25 GMT

My apologies ..... for some reason I thought this was an
Access newsgroup. My previous answer has no relevence to
Word mailmerge.

My apologies again,

Terry

>-----Original Message-----
>Zachary,
[quoted text clipped - 38 lines]
>>
>.

Reply to this Message

Doug Robbins - 06 Feb 2005 22:30 GMT

Remove the hyphens (subtraction signs) from the data source so that you
either have 5 or 9 digit zip codes. Then the conditional field switch
construction that Graham has on his website will work fine.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am experiencing the exact same situation as Richard originally wrote on
> 2/4/05. When merging zip codes, leading zero is dropped on 5 digit zip
[quoted text clipped - 14 lines]
> I tried different variations on the swith syntax with no luck. Any
> suggestions would be greatly appreciated!

Reply to this Message