Splitting a text file into multiple files

kristinfreitas

I have a large text file that has many page breaks that are denoted by a line "___________________".  I need to create separate text files for each section (create a separate file at each page break).  I am new to using Alteryx and not sure how I can do this.  Thanks in advance!

danilang

@kristinfreitas

Here you go. 

The mulit-row formula  creates a new filed called FileSuffix that get incremented every time it finds a "_______".  The output tool is configured to add the suffix to the output file name and so creates a new file every time the suffix changes

It currently includes the "__________" row in the output files.  If you want to remove them add a filter after the multi-row tool and set the custom filter to 

!Startswith( [Field_1],"________")

Dan

Split text files.yxmd