Options to parse table field?
Posted on 2014-10-28
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?