Loading ...
Sorry, an error occurred while loading the content.

21859Re: [Clip] add commas in address string

Expand Messages
  • Mike Breiding - Morgantown WV
    Jul 1, 2011
    • 0 Attachment
      On 7/1/2011 9:19 AM, John Shotsky wrote:
      > State and zip are easy. City has no distinguishing part to separate it
      > from the address. If there are a limited number
      > of cities, you could use a look up table. But even that could cause
      > problems, if a street name is also used in a city
      > name. I'd suggest you do the state and zip using regex, but add the
      > comma for the city manually. Regards, John

      Thanks, John.
      Will probably just do as much as I can with S&R and then finish up manually.
      Thanks,
      -Mike
      ==================

      >
      > From: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
      > [mailto:ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>]
      > On Behalf Of Mike Breiding - Morgantown WV
      > Sent: Friday, July 01, 2011 06:06
      > To: NoteTab Clips
      > Subject: [Clip] add commas in address string
      >
      > Postal code:
      > I need to replace the space in front of the first number with a comma
      >
      > State abbreviation:
      > I need to replace the space in front of the first letter with a comma
      >
      > City :
      > I need to replace the space in front of the first letter with a comma
      >
      > 125 N. Main Street City ST 11111
      >
      > Then I will paste into Excel
      >
      > Do-able?
      > Thanks,
      > -Mike
    • Show all 25 messages in this topic