Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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