+ Reply to Thread
Results 1 to 3 of 3

Easy way to parse...

  1. #1
    Diane
    Guest

    Easy way to parse...

    Does anyone know of an easy way to separate fields in a single cell? I have
    a database of about 1000 rows and one column is city, state and sometimes
    zip which I need to separate to three columns. The problem is that there is
    no consistent pattern between them. Some include the zip; some don't.

    Any help would be appreciated.

    Thanks,
    Diane



  2. #2
    Bob Phillips
    Guest

    Re: Easy way to parse...

    Diane,

    Unless you have some rules, it will be difficult. For instance

    San Fancisco California

    could be interpreted as a 2 name city, 2 name state, or one and one and a
    ZIP.

    What delimiter do you have, if it is not space, you could use Data>Text to
    Columns with that delimiter.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Diane" <[email protected]> wrote in message
    news:[email protected]...
    > Does anyone know of an easy way to separate fields in a single cell? I

    have
    > a database of about 1000 rows and one column is city, state and sometimes
    > zip which I need to separate to three columns. The problem is that there

    is
    > no consistent pattern between them. Some include the zip; some don't.
    >
    > Any help would be appreciated.
    >
    > Thanks,
    > Diane
    >
    >




  3. #3
    Bucky
    Guest

    Re: Easy way to parse...

    Diane wrote:
    > Does anyone know of an easy way to separate fields in a single cell?

    I have
    > a database of about 1000 rows and one column is city, state and

    sometimes
    > zip which I need to separate to three columns. The problem is that

    there is
    > no consistent pattern between them. Some include the zip; some don't.


    You can do it, but it won't be easy since you don't have a consistent
    pattern. You'll probably have to identity every possible pattern, then
    write a complex formula using IF and string fuctions. It may help to do
    the parsing into several intermediate columns, that way the formulas
    won't be too ridiculous.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1