Split Data

[Lez]

Sorry to break this tread, the followup I send is not appearing, so
re-posting

Hi John,

Many thanks for your assistance, The data does have consistencey, although
the charaters we have to split the field are used between colours and sizes.
Sorry I meant "colon" in my previous post.

A typical value would be Colour: Silver/Grey / Size: Small: Chest : 35
Inch: 88Cm / (this value is in field name 'style')

So for this value I would want to end up with 2 fields

1. Size which I would want to contain "Small: Chest : 35 Inch: 88Cm"
2. Colour which would contains "Silver/Grey /"

I have found some info on 'InStr' and have created a test query with this
code:

size: Mid([style],(InStr(1,[style],":"))+1)

Which gives me this result:

Silver/Grey / Size: Small: Chest : 35 Inch: 88Cm /

So reading from left to right I need to find the last / before the 2nd : to
create the field values for colour and using the 2nd : to find the values
for the size field

Hopefully that makes sense, but I gather it's just a case of creating the
correct 'InStr' function to echeive this.

Thanks again
Lez