Solved

Options to parse table field?

Posted on 2014-10-28
3
115 Views
Last Modified: 2014-11-04
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?
0
Comment
Question by:sandshakimi
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40408472
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
 

Author Comment

by:sandshakimi
ID: 40408550
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
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40408567
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now