If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Split Data cell
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. |
#2
|
|||
|
|||
Split Data cell
On Tue, 28 Oct 2008 15:43:16 -0000, "Lez"
wrote: 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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Split Data cell
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" wrote in message ... On Tue, 28 Oct 2008 15:43:16 -0000, "Lez" wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Split Data cell
On Tue, 28 Oct 2008 15:43:16 -0000, "Lez"
wrote: 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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|