Question

Locked

I'm looking to find a solution to this problem. please can someone help?

By MiLOS Designs ·
Below is an example of a CSV output I receive from a website where I sell my products:

2010-05-28 12:26:53,36714734,"","",0,0,0,"MiLOS DBO Sneakers - White - Female","Graceleigh Broderie","Graceleigh Broderie",199,10

I am interested in a formula that can extract "MiLOS DBO Sneakers - White - Female" from the above string. In addition, if it possible to also extract the "199" and "10" in separate columns.

I would be very appreciative if someone could help me.

Apologies, I'm importing the data into Microsoft Excel.

Kind Regards

Jonathan Heavens

This conversation is currently closed to new comments.

14 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

What program are you using to manipulate the data?

by Darryl~ Moderator In reply to I'm looking to find a sol ...

Are you importing it into Access or another database?
Are you opening it in a spreadsheet?
Are you just opening it as a text file in Notepad or something?

We need a little more info on what you're trying to do.

Collapse -

Apologies

by MiLOS Designs In reply to What program are you usin ...

Apologies Darryl, my ignorance thought that this site is primarily to do with Microsoft Excel.

I am importing the data into Excel. The formulas I am attempting to use are FIND, MID, LEN etc but I am having no luck.

Kind Regards

Jonathan Heavens

Collapse -

What do you want done with these strings?

by NexS In reply to Apologies

Do you want the data to just be put into columns?
Can you give a little bit more info?

Collapse -

Ideally, the way I think I understand what you're

by Darryl~ Moderator In reply to Apologies

trying to accomplish....

I'd import the csv into a database, whether it be Access or OpenOffice's Base...everthing would automatically be sorted into the columns you specified & you could run a couple simple queries to extract the info you want from what looks like the "description" or "product" field.

Collapse -

now i'm gonna pick on you

by PurpleSkys In reply to Ideally, the way I think ...

just cause you're not behind me to "smack" me....check your spelling on "weather", should be "whether"

Collapse -

I have no idea what you're talking about......

by Darryl~ Moderator In reply to now i'm gonna pick on you

besides....I could have been talking about "cloud" computing.....you just never know with me. :)

Collapse -

ppfftt

by PurpleSkys In reply to I have no idea what you'r ...

pa-lease...whatever do you take me for? (be careful how you answer that )

Collapse -

The way that is formatted (the csv file), it should

by Darryl~ Moderator In reply to I'm looking to find a sol ...

inport into Excel fine & in the separate columns you desire....the " around certian fields just designate them as text...if you're getting them in the cells once imported into Excel, you would have to do a "find/replace" to remove them....quite a hassle....thus the reason I said a database would be nicer to work with.
After you have them in the Excel sheet, all the "product descriptions" should be in the same column.....then you should be able to just do a "a - Z" sort & they would all show up together for you to copy & past or whatever it is you want to do....make sure you extend the sort to include all columns.

I still say a database would be easier....it kind of looks like you're trying to use Excel as a database...that's a common mistake many people try to do.

Collapse -

Thank you for all your input

by MiLOS Designs In reply to The way that is formatted ...

First of I would like to say a big thank you to everyone showing interest in my query. Basically, the background is that I run a business selling virtual products in the virtual world of Second Life. My products are listed on a website and sales are recorded. I can have a look at all previous sales but I can only copy and paste the CSV data from the webpage; hence why I am getting all the data into one cell. I don't have ACCESS, and I am simply interested in seeing if there is a way to extract the strings of text from each line, separating the information into separate columns. This is all in order to do some product analysis on sales.

Collapse -

Have you tried....

by Darryl~ Moderator In reply to Thank you for all your in ...

a copy and paste into a Notepad file & save it as filename.csv? (or just rename it from a .txt to a .csv extention).

I've done that before in situations like you're attempting when I can't copy into a spreadsheet properly....then you should be able to just open it in Excel & it will already be formatted for the cells....works pretty slick :)

Back to Software Forum
14 total posts (Page 1 of 2)   01 | 02   Next

Software Forums