Alteryx Designer Desktop Discussions

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

Formatting Delimited File with page headers

speddakama
6 - Meteoroid

I have input text file that I need to format to be in csv or excel format for analysis. I am adding In.txt and Out.txt for reference.

Input

speddakama_0-1588731538576.png

Output

speddakama_1-1588731581172.png

 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @speddakama ,

 

I'm sharing with you a suggestion showing how to do it. Since it was a simple file header to generate, I've used the select tool to do it, but we could do that automatically with regex parsing as well.

fmvizcaino_0-1588733284270.png

 

Workflow attached.

Best,

Fernando Vizcaino

 

speddakama
6 - Meteoroid

Thank you. Works great

Labels