How can I import these .txt data in a clean way.

[Kinetic_analytics]

Hello:

Good afternoon. I want to import the text data in a clean separate columns. How can I do that? I have attached txt file for your information.

Thanks

[Felipe_Ribeir0 · Accepted solution]

Hi @Kinetic_analytics 

This file is delimited by width. So, import it as a flat file:

[Kinetic_analytics]

@Felipe_Ribeir0  Thank you. 

[JeffK]

I'm assuming you are need of the rows of data starting with '0001 Transit' and organized into the columns appropriately. You can read in the .txt. file as a Flat ASCII file and then split the headers off from the data using the Filter tool. From there you'll want to use the Parse tools (Text to Columns or RegEx) to organize the table. I've attached the a workflow showing the first 2 steps I mentioned.