Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Search and extract words from continuous text file, then paste text to columns

FraM
6 - Meteoroid

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 nameCompany description
Company 1Company 1: Company 1 Description
Company 2Company 2: Company 2 Description

 

Looking forward to your help! 

10 REPLIES 10
binuacs
20 - Arcturus

@FraM the below post will give you an idea of combining the files

 

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten

Labels