Hi guys,
Here is my problem. I have a .csv file that has thousands of entries of car makes, models, year etc. Unfortunately my customer has given me the file from their DB and each entry with all the data is in a SINGLE CELL for each record. I need to break apart each of these and place them into separate columns. So here is the current structure:
chevy070522N5800
Which should be broken into 4 columns with the following headings:
Make / Date of Delivery / New-Used / Inv. Price
Chevy 070522 N 5800
When parsing the first few characters, keep in mind that this first part (Chevy in this example) may have any number of Characters from 1-5, but no more than 5. I assume I should just look at all alpha characters up until the first date character and strip those all off and put them into another adjacent column? The same is true of the last part of the entry...
Inv. Price can have up to 7 Characters in their entry. Again I assumed that I should just strip all numeric digits from the end of the entry and place those in another column and then just convert that to a currency format?
Any thoughts on the best way to accomplish this would be greatly appreciated. I just bought the Mr Excel Live Lessons Set from Borders yesterday.. even if someone could point me to the right place to start doing my own research on this..again appreciated.
Thanks
Here is my problem. I have a .csv file that has thousands of entries of car makes, models, year etc. Unfortunately my customer has given me the file from their DB and each entry with all the data is in a SINGLE CELL for each record. I need to break apart each of these and place them into separate columns. So here is the current structure:
chevy070522N5800
Which should be broken into 4 columns with the following headings:
Make / Date of Delivery / New-Used / Inv. Price
Chevy 070522 N 5800
When parsing the first few characters, keep in mind that this first part (Chevy in this example) may have any number of Characters from 1-5, but no more than 5. I assume I should just look at all alpha characters up until the first date character and strip those all off and put them into another adjacent column? The same is true of the last part of the entry...
Inv. Price can have up to 7 Characters in their entry. Again I assumed that I should just strip all numeric digits from the end of the entry and place those in another column and then just convert that to a currency format?
Any thoughts on the best way to accomplish this would be greatly appreciated. I just bought the Mr Excel Live Lessons Set from Borders yesterday.. even if someone could point me to the right place to start doing my own research on this..again appreciated.
Thanks
