Options to parse table field?

The challenge is trying to automate data extraction from a database, from the Laptop table,  in which the Description field has much of the content I need to get.

Within the Description field is:  RAM, CPU, Model, Screens Size and other specs I need. The goal is to separate out the specs into individual fields, into a new DB.

*There's no consistency in the field. On the front end, it was just treated as a text area. So a user would put in the specs in any order, or syntax, like "3GB" or "3GB RAM", or "RAM 3GB"

I perceive this as a mighty challenge...where should I begin?
sandshakimiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Separate each element out, and create a table which correlates each element into the correct version.

So a table would have:

3GB                 Ram: 3Gb
3GB Ram        Ram: 3Gb
RAM 3GB        Ram: 3Gb

This way, the number of permutations of correct information gets reduced.
0
sandshakimiAuthor Commented:
Phllip, can you expand on that, more technically.

Keeping in mind that there are thousands of records, this needs an automation. Here's an example of what some fields look like.

Description Fieldfield1.PNG
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I don't know what you mean, "more technically".

You've posted this under Experts Exchange > Programming > Prog Languages > Query Syntax > Options To Parse Table Field, so I can't give you specific guidance about a programming language.

Your first line, "1GB Apple Powerbook G4 12-inch 1Ghz...", I would expect you to have several rows in another table:

1Gb
Apple
Powerbook
G4
12-inch
1Ghz

and each of which would tell you what characteristic are identified by that, together with a unified description:

1Gb                        Ram                       1 Gb
Apple                     Manufacturer       Apple Computers
Powerbook           Model                    Powerbook
G4                          Model 2                 G4
12-inch                  Screen size           12 inches
1Ghz                      Processor speed  1 Ghz

and then you match each string against this second table to get the characteristics.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.