06-08-2009
|
|
Registered User
|
|
|
Join Date: May 2009
Posts: 6
|
|
|
delete first number of even-numbered lines
Hello !
I am trying to delete a number from the even-numbered lines of a pipeline after having extracted and sorted the desired data from an original text file using sed...
Code:
sed -r 's/\([0-9]*\)[^\(]*\(([^\)]*)\),[^,]*,[^,]*,([^\(]*)[^:]*: [^ ]* \w*\=([0-9]*).*/\3,\1/g' | sort -n
then the data looks like :
Quote:
1,0.0833607576
1,0.0835698182
2,0.0834306364
2,0.0836052121
3,0.0836289697
3,0.0838195758
4,0.0837380909
4,0.0839200909
5,0.0837818182
5,0.0839539394
|
Now, I am trying to delete the number of the even-numbered lines so as to append the lines of same number together and to get something like :
Quote:
1,0.0833607576,0.0835698182
2,0.0834306364,0.0836052121
3,0.0836289697,0.0838195758
4,0.0837380909,0.0839200909
5,0.0837818182,0.0839539394
|
I thought of using something like :
- for deleting the number :
Code:
sed -r '1~2p;s/[0-9]*,(.*)/\1/g'
- for joining lines of same number :
Code:
awk '{if (NR%2==1) {getline X}; print $0,",",X}'
but yet, with the sed command line I don't get what I want :
Quote:
1,0.0833607576
0.0833607576
0.0835698182
2,0.0834306364
0.0834306364
0.0836052121
3,0.0836289697
0.0836289697
0.0838195758
4,0.0837380909
0.0837380909
0.0839200909
5,0.0837818182
0.0837818182
0.0839539394
|
I thank you for your precious help !
|
More UNIX and Linux Forum Topics You Might Find Helpful
Powered by 
Threaded Mode
