Solved

Options to parse table field?

Posted on 2014-10-28
3
119 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Data Field - SQL 11 41
Powershell finalizing the end of an array. 4 24
Sql case statement to calculate totals 5 36
T-SQL Query - Group By Year 3 31
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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