IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New 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
New Python :-)
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
New Of course. :-) Very nice. Thanks.
New Figured it was pretty easy, thanks, will try
--

Drew
New 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.
New Several hundred test cases ... not doing it manually
--

Drew
     How to import row-delimited data - (drook) - (5)
         Python :-) - (malraux) - (2)
             Of course. :-) Very nice. Thanks. -NT - (Another Scott)
             Figured it was pretty easy, thanks, will try -NT - (drook)
         Is it too painful to do manually or a scripted editor? - (Another Scott) - (1)
             Several hundred test cases ... not doing it manually -NT - (drook)

Remember, rank times IQ is a constant.
72 ms