How can I use Automator to extract specific Data from a text file?
I have several hundred text files that contain a bunch of information. I only need six values from each file and ideally I need them as columns in an excel file.
How can I use Automator to extract specific Data from the text files and either create a new text file or excel file with the info? I have looked all over but can't find a solution. If anyone could please help I would be eternally grateful!!! If there is another, better solution than automator, please let me know!
Example of File Contents:
Link Time = | DD/MMM/YYYY |
Random | Text |
161 179 | bytes of CODE memory (+ 68 range fill ) |
16 789 | bytes of DATA memory (+ 59 absolute ) |
1 875 | bytes of XDATA memory (+ 1 855 absolute ) |
90 783 | bytes of FARCODE memory |
What I would like to have as a final file:
EXCEL COLUMN1 | Column 2 | Column3 | Column4 | Column5 | Column6 |
MM/DD/YYYY | filename1 | 161179 | 16789 | 1875 | 90783 |
MM/DD/YYYY | filename2 | xxxxxx | xxxxx | xxxx | xxxxx |
MM/DD/YYYY | filename3 | xxxxxx | xxxxx | xxxx | xxxxx |
Is this possible? I can't imagine having to go through each and every file one by one. Please help!!!
Automator-OTHER