I have a database of 1154 records of products and one of 45 records of links to code samples. Both are currently in a flatfile CVS format. I need someone to write a script or use REGEX to convert this into a format that can be imported by Movable Type (see [url removed, login to view]).
For someone who know regular expressions well, this should be a 20 minute job.
Also, the current product database has separate listings for identical products that run on different platforms (e.g. windows, linux or mac). The duplicate products need to be removed, and the additional OS platforms are simply added on to the platform data field.
The product database is incomplete and not always up to date. So a third part of the job is to check that each product record links to a valid URL (e.g. a listing for Adobe Photoshop links to [url removed, login to view]) and to add in the name of the company that makes this product (e.g. Adobe). This will be a manual process. It is easy and does not require any technical skill.
The additional company information will be added to the Movable Type Formatted file.
This entire project could be done manually by someone in a few hours. But a coder who knows regex should be able to do it even faster.