How do I convert text file with report headers on multiple pages into the right format

[BC_O]

I'm a recent new user of the tool. I tried to input a text file (read it as fixed width text file) to get it into a format like excel where I can use Alteryx to vlookup (join tool) with another input table. The text file has the report headers and dotted lines on multiple pages, I don't know how to get rid of these so that I can get the below output to run further analysis.

Item	Description	Class	UOM	Sequence	Quantity	Usage Value
00-30430Z	LEMO CONNECTOR	C	EA	643	0	0
000-0450-23	Motor, Blower, Maxi-Tube II	B	EA	100	8245	338532.18

[Maskell_Rascal]

@BC_O 

Can you provide the actual .txt file? It would make it a lot easier to trouble shoot and find a solution if we know the structure of the data going in. 

Thanks!

Phil 

[Watermark]

This seems like you need a number of steps. Bring it in as a text, all the info in one field, skip the first number of lines, then start to parse or regex it out. Could need a couple of steps to do it, but like the last poster commented. If you post the actual sheet, there are people here who could split it out. 

[BC_O]

This is the actual text file. Because of data confidentiality, I switched to another smaller text file in similar format and replaced some sensitive data. 

[BC_O]

Thank you, @Maskell_Rascal . I attached the actual text file below. 

[BC_O]

Thank you @Watermark. I attached the actual text file as below. In the meantime, I will try to read up on parse or regex. 

[Maskell_Rascal · Accepted solution]

Hi @BC_O 

Thank you for providing a sample file. Try the attached packaged workflow. I created a FLAT file template that splits you data into fixed width columns. From there, there was a lot of filtering and parsing that needed to be done to get the data into a usable format, but the final output looks like this:

Hope this helps.

Cheers!

Phil

[BC_O]

@Maskell_Rascal  Thank you, it works perfectly. I just need to go through it to understand the flow.