Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
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