02-15-2013
Edit column using sort
Hi Expert,
Please kindly need your help, I dont have any idea how to make this input to be as output.
Thanks before
Code :
[paradigm@lemahabang EB]$ more input.dat
@zmap_fault HEADER , FALT, 80, 1
X (EASTING) , 1, 1, 1, 1, 15, 7, 0.1000000E+31, , 15, 7, 0
Y (NORTHING) , 2, 2, 1, 16, 30, 7, 0.1000000E+31, , 15, 7, 0
Z - FIELD , 3, 3, 1, 31, 45, 7, 0.1000000E+31, , 15, 7, 0
SEG I.D. , 4,35, 1, 46, 60, 7, 0.1000000E+31, , 15, 7, 0
@
784788.9 104383.1 0.000000 1.000000
784788.9 86665.28 0.000000 1.000000
784788.9 68947.42 0.000000 1.000000
768194.8 68947.42 0.000000 1.000000
751600.7 68947.42 0.000000 1.000000
751600.7 86665.28 0.000000 1.000000
751600.7 104383.1 0.000000 1.000000
768194.8 104383.1 0.000000 1.000000
784788.9 104383.1 0.000000 1.000000
755547.9 95036.69 0.000000 2.000000
755545.7 95010.64 0.000000 2.000000
755538.9 94985.38 0.000000 2.000000
755527.8 94961.69 0.000000 2.000000
755512.9 94940.27 0.000000 2.000000
755494.4 94921.78 0.000000 2.000000
755472.9 94906.78 0.000000 2.000000
755449.2 94895.73 0.000000 2.000000
755424.0 94888.97 0.000000 2.000000
755397.9 94886.69 0.000000 2.000000
755371.9 94888.97 0.000000 2.000000
755346.6 94895.73 0.000000 2.000000
755322.9 94906.78 0.000000 2.000000
755301.5 94921.78 0.000000 2.000000
755283.0 94940.27 0.000000 2.000000
755268.1 94961.69 0.000000 2.000000
755257.0 94985.38 0.000000 2.000000
755250.2 95010.64 0.000000 2.000000
755247.9 95036.69 0.000000 2.000000
755250.2 95062.73 0.000000 2.000000
755257.0 95087.99 0.000000 2.000000
755268.1 95111.69 0.000000 2.000000
755283.0 95133.11 0.000000 2.000000
755301.5 95151.59 0.000000 2.000000
755322.9 95166.59 0.000000 2.000000
755346.6 95177.64 0.000000 2.000000
755371.9 95184.41 0.000000 2.000000
755397.9 95186.69 0.000000 2.000000
755424.0 95184.41 0.000000 2.000000
755449.2 95177.64 0.000000 2.000000
755472.9 95166.59 0.000000 2.000000
755494.4 95151.59 0.000000 2.000000
755512.9 95133.11 0.000000 2.000000
755527.8 95111.69 0.000000 2.000000
755538.9 95087.99 0.000000 2.000000
755545.7 95062.73 0.000000 2.000000
755547.9 95036.69 0.000000 2.000000
755546.8 93139.06 0.000000 3.000000
755544.6 93113.02 0.000000 3.000000
755537.8 93087.76 0.000000 3.000000
755526.7 93064.06 0.000000 3.000000
755511.8 93042.64 0.000000 3.000000
755493.2 93024.16 0.000000 3.000000
755471.8 93009.16 0.000000 3.000000
755448.1 92998.11 0.000000 3.000000
755422.9 92991.34 0.000000 3.000000
755396.8 92989.06 0.000000 3.000000
755370.8 92991.34 0.000000 3.000000
755345.5 92998.11 0.000000 3.000000
755321.8 93009.16 0.000000 3.000000
755300.4 93024.16 0.000000 3.000000
755281.9 93042.64 0.000000 3.000000
755266.9 93064.06 0.000000 3.000000
755255.9 93087.76 0.000000 3.000000
755249.1 93113.02 0.000000 3.000000
755246.8 93139.06 0.000000 3.000000
755249.1 93165.11 0.000000 3.000000
755255.9 93190.37 0.000000 3.000000
755266.9 93214.06 0.000000 3.000000
755281.9 93235.48 0.000000 3.000000
755300.4 93253.97 0.000000 3.000000
755321.8 93268.97 0.000000 3.000000
755345.5 93280.02 0.000000 3.000000
755370.8 93286.78 0.000000 3.000000
755396.8 93289.06 0.000000 3.000000
755422.9 93286.78 0.000000 3.000000
755448.1 93280.02 0.000000 3.000000
755471.8 93268.97 0.000000 3.000000
755493.2 93253.97 0.000000 3.000000
755511.8 93235.48 0.000000 3.000000
755526.7 93214.06 0.000000 3.000000
755537.8 93190.37 0.000000 3.000000
755544.6 93165.11 0.000000 3.000000
755546.8 93139.06 0.000000 3.000000
and output as below
Code :
[paradigm@lemahabang EB]$ more output.dat
Cartograpic data in user defined format
....V....1....V....2....V....3....V....4....V....5....V....6....V....7
p input_file_name
784788.9 104383.1
784788.9 86665.28
784788.9 68947.42
768194.8 68947.42
751600.7 68947.42
751600.7 86665.28
751600.7 104383.1
768194.8 104383.1
784788.9 104383.1
99999
p input_file_name
755547.9 95036.69
755545.7 95010.64
755538.9 94985.38
755527.8 94961.69
755512.9 94940.27
755494.4 94921.78
755472.9 94906.78
755449.2 94895.73
755424.0 94888.97
755397.9 94886.69
755371.9 94888.97
755346.6 94895.73
755322.9 94906.78
755301.5 94921.78
755283.0 94940.27
755268.1 94961.69
755257.0 94985.38
755250.2 95010.64
755247.9 95036.69
755250.2 95062.73
755257.0 95087.99
755268.1 95111.69
755283.0 95133.11
755301.5 95151.59
755322.9 95166.59
755346.6 95177.64
755371.9 95184.41
755397.9 95186.69
755424.0 95184.41
755449.2 95177.64
755472.9 95166.59
755494.4 95151.59
755512.9 95133.11
755527.8 95111.69
755538.9 95087.99
755545.7 95062.73
755547.9 95036.69
99999
p input_file_name
755546.8 93139.06
755544.6 93113.02
755537.8 93087.76
755526.7 93064.06
755511.8 93042.64
755493.2 93024.16
755471.8 93009.16
755448.1 92998.11
755422.9 92991.34
755396.8 92989.06
755370.8 92991.34
755345.5 92998.11
755321.8 93009.16
755300.4 93024.16
755281.9 93042.64
755266.9 93064.06
755255.9 93087.76
755249.1 93113.02
755246.8 93139.06
755249.1 93165.11
755255.9 93190.37
755266.9 93214.06
755281.9 93235.48
755300.4 93253.97
755321.8 93268.97
755345.5 93280.02
755370.8 93286.78
755396.8 93289.06
755422.9 93286.78
755448.1 93280.02
755471.8 93268.97
755493.2 93253.97
755511.8 93235.48
755526.7 93214.06
755537.8 93190.37
755544.6 93165.11
755546.8 93139.06
99999
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Col1 Col2 Col3 Col4
12 Completed 08 0830
12 In Progress 09 0829
11 For F U 07 0828
Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am... (10 Replies)
Discussion started by: tamahomekarasu
10 Replies
2. Shell Programming and Scripting
Hi,
This is my input file:
ali 5 usa abc
abu 4 uk bca
alan 6 brazil bac
pinky 10 utah sdc
My desired output:
pinky 10 utah sdc
alan 6 brazil bac
ali 5 usa abc
abu 4 uk bca
Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Discussion started by: patrick87
3 Replies
3. Shell Programming and Scripting
How can I use awk to pick a particular column and work on it? For example, I want to count the number of characters in column10 that are separated by |?
Thank you. (2 Replies)
Discussion started by: ivpz
2 Replies
4. Shell Programming and Scripting
I have an input file like this...
AAAlkalines Energizer
AAAlkalines Energizer
AAAlkalines Energizer
AAAlkalines Sunlight
AAAlkalines Sunlight
AAAlkalines Sunlight
AAAlkalines Energizer
AAAlkalines Energizer
AAAlkalines Energizer
AAASalines ... (7 Replies)
Discussion started by: malcomex999
7 Replies
5. Shell Programming and Scripting
FILE A:
9780743551526,(Abridged)
9780743551779,(Unabridged)
9780743582469,(Abridged)
9780743582483,(Unabridged)
9780743563468,(Abridged)
9780743563475,(Unabridged)
FILE B:
c3saCandyland 9780743518321 "CANDYLAND" "MCBAIN, ED" 2001
c3sbCandyland 9780743518321 ... (7 Replies)
Discussion started by: glev2005
7 Replies
6. Shell Programming and Scripting
Mar 26 12:32:53 name sshd: 192.168.1.14
Mar 27 12:42:53 name sshd: 192.168.1.14
how to make this data in output as:
"Mar 26 12:32:53","name","sshd","192.168.1.14"
"Mar 27 12:42:53","name","sshd","192.168.1.14"
anyone plzz help me out!!!!!!!!!!!!!! (4 Replies)
Discussion started by: jacky29
4 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I am running on AIX.I have a question about sorting in UNIX.
if my file is something like this:
a c
b d
a b
b c
a a
I want to sort on column 1 only. The following statement does not seem to work, it still considers the rest of the line in the sorting results: sort... (2 Replies)
Discussion started by: gio001
2 Replies
8. UNIX for Dummies Questions & Answers
If my data is numerical :
1 = 101
2 = 102
3 = 104
4 = 104
7 = 103
8 = 103
9 = 105
I need the result like below:
1 = 101
2 = 102
3 = 103
4 = 103
7 = 104
8 = 104
9 = 105 (4 Replies)
Discussion started by: GeodusT
4 Replies
9. Shell Programming and Scripting
Hello Team,
I want to know if there is any one liner command , using which I can edit multiple column of a file.
input file input.txt (comma separated),
taran, 12.45, uttam, 23.40, babay
karan, 12.45, raju, 11.40, rahulg
I want to update, 2nd and 4th column,
but want all those column... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
10. Shell Programming and Scripting
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies