Free Trial

Alteryx Designer Desktop Discussions

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

Split file based on a word that appears several times

aorozco
6 - Meteoroid

I need to split a file that has multiple headers as follows: 

 

  • Break up the file based on the header. Headers always include the word TITLE
  • Write each file to a csv file
  • Assign a unique name to each file
  • Sometimes before the first "TITLE", the file contains some random text I don't need so that would need to be removed. 

Can someone advise? 

 

I'm attaching a dummy file similar to the one I need to split and a screenshot of the desired outputs as reference.

 

Thanks

2 REPLIES 2
binuacs
21 - Polaris

@aorozco One way of doing this

image.png

aorozco
6 - Meteoroid

Thank you very much!

Labels
Top Solution Authors