Dear Community, aiming to build a workflow to extract certain words from a continuous text between delimiters from a text file and paste respective words to columns.
Specifically:
1. Import ~ 100 text files with running text; in each file:
2. Search for alt=
3. Paste text that is following between "" to column 1 (Company name)
4. Search for "company-name" title=
5. Paste text that is following between "" to column 2 (Company description)
Example File 1:
xxxxxxxxxx alt="Company 1" yyyyyyy "company-name" title="Company 1: Company 1 Description"zzzzzzz alt="Company 2"yyyyyyy "company-name" title="Company 2: Company 2 Description"zzzzzzz
Note: Each file has ~ 40 Companies in its text and total text lenght per file is very long.
Output:
| Company name | Company description |
| Company 1 | Company 1: Company 1 Description |
| Company 2 | Company 2: Company 2 Description |
Looking forward to your help!
