Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start 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