Data Fixing.

From: Phil (harlequintp_at_blazemail.com)
Date: 04/21/04

  • Next message: Vishal Parkar: "Re: Data Fixing." 
    Date: Wed, 21 Apr 2004 00:40:05 -0700

    Hi all,

    Just wondering if someone can help me whith some data I am
    trying to seperate out, the examples are shown as below

    Clarice Apartment - 2 bedroom Apartment
    The Beech - 4 bedroom Detached
     

    What I want to say is everything before the first (-) is
    one column, then what is after the (-) but before the last
    SPACE is another column and what is after the last space is
    another column, it should end up looking something like this

    Field Headings NAME Bed Type
                    Clarice Apartment 2 Bedrooms Apartment
                    The Beech 4 Bedrooms Detached

    If anyone could help I would be grateful.

    Thanks Phil

  • Next message: Vishal Parkar: "Re: Data Fixing."