10-13-2010
Grep line to separate column
Hi friends
I have a file like this
Quote:
=001 abcd002432236
=035 \\$a(abc)32780281
=035 \\$a(xyz)7550102
=001 abcd002432237
=035 \\$a(abc)37909749
=035 \\$a(xyz)8777598
=001 abcd000509975
=035 \\$a(abc)43067318
=035 \\$a(xyz)8749126
=035 \ \\$a(abc)430673199
=001 abcd000509977
=035 \\$a(xyz)8749128
=001 abcd000509977
:
:
number of =035 is not constant
I want output like this probably in excel sheet .
Quote:
=001 abcd002432236 =035 \\$a(abc)32780281
=035 \\$a(xyz)7550102
=001 abcd002432237 =035 \\$a(abc)37909749
=035 \\$a(xyz)8777598
=001 abcd000509975 =035 \\$a(abc)43067318
=035 \\$a(xyz)8749126
=035 \ \\$a(abc)430673199
=001 abcd000509977 =035 \\$a(xyz)8749128
Please help
Waiting for reply
Thanks a lot
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know "awk -F:" will separate out the column by ":" , now if I what to separate out the column by space also , what can I do ?
for example :
#ps -ef |grep telnet
root 10159 702 0 15:45 ? 00:00:00 in.telnetd: 192.168.0.1
how to separate out the column so that the column as below,
... (6 Replies)
Discussion started by: ust
6 Replies
2. Shell Programming and Scripting
hi,
how to print a row which contains a perticular word in its third column using grep, cut,
or any thing else.
thanks (2 Replies)
Discussion started by: useless79
2 Replies
3. Shell Programming and Scripting
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
Discussion started by: poliver
3 Replies
4. Shell Programming and Scripting
How do I grep/check the on-hand value on the second line of show_prod script below? In this case it's a "3".
So if it's > 0, then run_this, otherwise, quit.
> ./show_prod
Product Status Onhand Price
shoe OK 3 1.1 (6 Replies)
Discussion started by: joker_789us
6 Replies
5. Shell Programming and Scripting
$ cat file.log
Message Number = : Sending message 10:50:16^|^reqhdr.dummyid^=^02^|^reqhdr.timezone^=^GMT+05:30^|^DUMMYREQUEST^=^BH||||||||||||||||||$BD|OL|C|V||DummyAcctNo|02||24/12/2011|ST_DDM|DDM||||||||reqUUID110612105016$BT||||||||||||||||||$] Length
I have the above line in the... (4 Replies)
Discussion started by: kalidass
4 Replies
6. Shell Programming and Scripting
Suppose i have the following data :
cat file.txt
12431,123334,55353,546646,14342234,4646,35234
123123,3535,123434,132535,1234134,13535,123534
123213,545465,23434,45646,2342345,4656,31243
2355425,2134324,53425,342,35235,23434,234535
3423424,234234,65465,,2344,35436,234524,234... (7 Replies)
Discussion started by: Ravi Tej
7 Replies
7. Shell Programming and Scripting
Hi,
I have the following file,
chr1 100 200 20
chr1 201 300 22
chr1 220 345 23
chr1 230 456 33.5
chr1 243 567 90
chr1 345 600 20
chr1 430 619 21.78
chr1 870 910 112.3
chr1 914 920 12
chr1 930 999 13
My output would be
peak1 20 22 23 33.5 90
peak2 20 21.78 112.3 12 13
Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
8. Shell Programming and Scripting
hi Gurus,
I need separate a file which is one huge line to multiple lines based on certain number of charactors. for example:
abcdefghi high abaddffdd
I want to separate the line to multiple lines for every 4 charactors.
the result should be
abcd
efgh
i hi
gh a
badd
ffdd
Thanks in... (5 Replies)
Discussion started by: ken6503
5 Replies
9. UNIX for Dummies Questions & Answers
I have one command which provide following output related to file system and disk space utilization
Filesystem kbytes used avail %used Mounted on
/dev/lvol3 131072 73407 54088 58% /
/abc/lvol1 59797 30314 2350300 ... (8 Replies)
Discussion started by: Nakul_sh
8 Replies
10. Shell Programming and Scripting
Hi all:
I have the following input file:
function-v such_as-hash-n 6.5328
function-n such_as-head-n 2.5586
function-a such_as-headphone-n 8.0794
function-n such_as-health-n 3.1938
function-v such_as-healthcare-n 5.2845
function-n such_as-hearing-n 9.5367... (9 Replies)
Discussion started by: owwow14
9 Replies