Regular Expressions- extracting data from files
Posted on 2008-10-25
I've been learning Regular Expressions in preparation for an upcoming project, and need a little advice on how to preceed to the next step.
I have around 1,100 reports that I need to extract various data from. The reports are in .wpd format (version 12), and I've converted a test group of 150 files to .txt format.
I've created and tested several RegEx strings, and they all seem to work well.
Now, how do I 'use' these regex strings to parse and extract the data from the 1,100 text files and push that data into either/or-
-individual text files (1 for each corresponding report) for further refinement
-into a single .txt, .csv or other format
I have a variety of tools at my disposal (vb.net/visual source.net 2003, MS Office 2003, parse-o-matic, textpad, etc..), and am not against purchasing/acquiring/learning other software to help in this task (should the .net learning curve be too overwhelming).
Should I jump into coding a solution? If so, what platform or tools would be appropriate?
Is there a more complete 'packaged' solution available for this task? What are your experiences and preferences regarding these?
Thanks again for your help!