How to import row-delimited data

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #404,199 by drook 8/21/15 12:33:44 PM Reply	How to import row-delimited data I've got data that looks like this: --- ================================ Test case 1 ================================ Step 1 Step 2 Step 3 ================================ Test case 2 ================================ Step 1 Step 2 ================================ Test case 3 ================================ Step 1 Step 2 Step 3 Step 4 --- It's output from a tool that has no options for CSV or otherwise. I'd like to get it into a spreadsheet so I can add a column for results. Any ideas? -- Drew
Post #404,201 by malraux 8/21/15 12:56:03 PM Reply	Python :-) https://gist.github.com/scottanderson42/8d8f2ee9869eab0ae221 Regards, -scott Welcome to Rivendell, Mr. Anderson.
Post #404,203 by Another Scott 8/21/15 1:07:55 PM Reply	Of course. :-) Very nice. Thanks.
Post #404,214 by drook 8/21/15 8:33:34 PM Reply	Figured it was pretty easy, thanks, will try -- Drew
Post #404,202 by Another Scott 8/21/15 12:56:35 PM Reply	Is it too painful to do manually or a scripted editor? IIRC, when I import a text file into Excel, I can set the column breaks manually, then quickly edit out the rows I don't want. You might be able to make a script in UltraEdit or your favorite editor as well. I'm sure there's a way to do it with scripting Excel, but the time it takes may be longer than doing it via the above. HTH. Cheers, Scott.
Post #404,216 by drook 8/22/15 12:35:43 AM Reply	Several hundred test cases ... not doing it manually -- Drew

How to import row-delimited data - (drook) - (5) - Aug. 21, 2015, 12:33:44 PM EDT

Python :-) - (malraux) - (2) - Aug. 21, 2015, 12:56:03 PM EDT

Of course. :-) Very nice. Thanks. -NT - (Another Scott) - Aug. 21, 2015, 01:07:55 PM EDT

Figured it was pretty easy, thanks, will try -NT - (drook) - Aug. 21, 2015, 08:33:34 PM EDT

Is it too painful to do manually or a scripted editor? - (Another Scott) - (1) - Aug. 21, 2015, 12:56:35 PM EDT

Several hundred test cases ... not doing it manually -NT - (drook) - Aug. 22, 2015, 12:35:43 AM EDT

iwethey.org

Six harpies are singin' on the lee!
48 ms