Split Data cell

[Lez]

Hi Guys,

I am looking for a solution to a problem I have. I have a spreadsheet that
has a feild in which comes in the following format:

Colour: Silver/Black / Size: 42 Ladies Uk 14: Chest 38 Inch /

What I need to do is import the data on the sheet but the value in this
field needs to be split into 2 fields 'Colour' and 'Size'

The the value seperator is a forward slash '/' however, to complicate things
the sheet also has additional semi colons ':' in addition to the Colour and
Size seperator.

So in this example what I would want is

Colour
Silver Black

Size
42 Ladies Uk 14 Chest 38 Inch

If anyone has any suggestions I would be most grateful.

 

[John W. Vinson]

Hi Guys,

I am looking for a solution to a problem I have. I have a spreadsheet that
has a feild in which comes in the following format:

It sounds like you're using Excel, rather than Microsoft Access (the subject
of this newsgroup). I'd suggest reposting your question in an Excel forum.

 

[Lez]

Hi John,

yes the data is from an excel spreadsheet, however, I need to split the
value of the field once it imported into Access. So when I import the sheet
data I then need to split the value of the field and create 2 new feilds
'Colour' & 'Size' from the one field 'Style'

Regards
Lez

 

[John W. Vinson]

Hi Guys,

I am looking for a solution to a problem I have. I have a spreadsheet that
has a feild in which comes in the following format:

Colour: Silver/Black / Size: 42 Ladies Uk 14: Chest 38 Inch /

What I need to do is import the data on the sheet but the value in this
field needs to be split into 2 fields 'Colour' and 'Size'

The the value seperator is a forward slash '/' however, to complicate things
the sheet also has additional semi colons ':' in addition to the Colour and
Size seperator.

So in this example what I would want is

Colour
Silver Black

Size
42 Ladies Uk 14 Chest 38 Inch

I'm confused. It sounds like the / character is used BOTH as a delimiter
between colours, and between the different fields. Or do you want to trigger
the splitting based on the colon-terminated fieldnames Colour: and Size:? How
consistant is the data? What's the meaning of the trailing slash? You say
"additional semicolons" but the character you cite is a colon.

More examples please!