Convert Ascii file(IEC) to two column

ROOT
1

I would like to convert an ICE file two a two column file so that I can get root to plot it. The file is something like the following

A004 DET02 1 1 0 A004 361.080000 361.180000 4096 A00419/04/13 14:08:23 A004 13.9927 0.454823 0 0 A004 2.3948 0.00120979 -3.57846e-007 5.24525e-011 1 A004 A004 A004 A004 A004SPARE A004 121.78 237 661.67 1424 A004 1408.02 3065 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 121.78 2.66212 661.67 3.54338 A004 1408.02 4.25141 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 0 0 0 0 A004 A004 A004 A004 A004 A004 A004 A004 A004 A004 A004 A004USERDEFINED A004 0 0 0 0 0 0 A004 5 0 0 0 0 0 A004 10 0 0 0 0 0 A004 15 0 0 0 0 0 A004 20 0 0 0 0 0 A004 25 0 0 0 1 2 A004 30 2 5 4 3 6 A004 35 5 5 4 4 6 A004 40 4 8 3 6 7 A004 45 3 2 5 3 2 A004 50 3 7 5 6 4 A004 55 2 2 2 3 6

The useful lines are the one after USERDEFINED.
The first columns (A004) are not used at all.
The second column is the first channel number in a 5-channel set and
the 3rd-7th are the events.

How can I convert it in order to plot it?
Thank you very much in advance!

2

If you just need it for one or several files, take any editor (e.g. emacs) and select a “rectangle area” (i.e. select these two columns), then save the selection into another file.
You can also easily use “sed” or “awk” or “perl” to extract these two columns.

3

That’s exactly what I thought, but the values are seperated by spaces and I want the data from 3rd to 7th column to become one column.