Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Copy a field into n line in another place

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Copy a field into n line in another place
# 8  
Old 05-08-2012
thanks alot but there is a little problem:
the output of your script contains the values of 1st field (header must be deleted):
Code:
? ? ?  ? 20060101  
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60

i want this output
Code:
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60

# 9  
Old 05-08-2012
Quote:
Originally Posted by oreka18
thanks alot but there is a little problem:
the output of your script contains the values of 1st field (header must be deleted):
Code:
? ? ?  ? 20060101  
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60

i want this output
Code:
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60

add to an asteriks and try again
Code:
# awk '/^ *200?/........

so
Code:
# awk '/^ *200?/{x=$1$2;y="? ? ?";next}{sub(/^./,"",$3);if(/^##/)print "##";else print $1,y,$3,"?",x,$5,$6}' yourfile

or
Code:
/usr/xpg4/bin/awk ....

or
Code:
nawk ...

Last edited by ygemici; 05-08-2012 at 06:35 AM..
This User Gave Thanks to ygemici For This Post:
oreka18
# 10  
Old 05-08-2012
I get:
Code:
BST ? ? ? 20060101 Pn 0 1236 45.64
HSH ? ? ? 20060101 Pg 0 1237 9.75
BST ? ? ? 20060101 Pn 4 1237 10.80
###
DHR ? ? ? 20060101 Pg 0 1316 27.32
DHR ? ? ? 20060101 Sg 0 1316 30.52
LIN ? ? ? 20060101 Pg 0 1316 32.78
GHG ? ? ? 20060101 Pg 0 1316 34.96

Try nawk instead of awk (only guessing, I still do not know your OS and version)?
This User Gave Thanks to Scrutinizer For This Post:
oreka18
# 11  
Old 05-08-2012
oh I'm sorry, i forget to tell to you. it's fedora 13.
actually in my original file there is no "###" between section maybe it occur such that problem
# 12  
Old 05-08-2012
Quote:
Originally Posted by oreka18
oh I'm sorry, i forget to tell to you. it's fedora 13.
actually in my original file there is no "###" between section maybe it occur such that problem
i tried in fc14 Smilie is it ok ?
Code:
# awk '/^ *200?/{x=$1$2;y="? ? ?";next}!/^ *$/{sub(/^./,"",$3);print $1,y,$3,"?",x,$5,$6;}' yourfile
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96

Last edited by ygemici; 05-08-2012 at 09:21 AM..
This User Gave Thanks to ygemici For This Post:
oreka18
# 13  
Old 05-08-2012
Quote:
Originally Posted by ygemici
i tried in fc14 Smilie is it ok ?
Code:
# awk '/^ *200?/{x=$1$2;y="? ? ?";next}!/^ *$/{sub(/^./,"",$3);print $1,y,$3,"?",x,$5,$6;}' yourfile
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96

but my input file and output file are?
[orginal_file]
Code:
2006 0101 1236 49.3 L  37.902  48.482  0.0  Teh  5 0.2 2.7LTeh                1 
 GAP=238                                                                       E 
 Iranian Seismological Center, Institute of Geophysics, University of Tehran   6 
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO SNR AR TRES  W DIS CAZ7 
 HSH  SZ E    0   1237 29.15      2843.4 0.04                           126 238 
 AZR  SZ E    0   1237 58.33       598.9 0.14                           221 264 
 MRD  SZ E    0   1238  5.28       615.6 0.22                           258 291 
 BST  SZ E    0   1237 31.34       897.3 0.08                           143 261 
 SHB  SZ E    0   1238  2.03       222.2 0.16                           254 279 
 AZR  SE EPn  0   1236 40.89                                     0.0    0.0   0 
 BST  SN EPn  0   1236 45.64                                     0.0    0.0   0 
 HSH  SZ EPg  0   1237 9.75                                     -0.0    126 238 
 BST  SZ EPn  4   1237 10.80                                    -3.6    143 261 
 AZR  SZ EPn  0   1237 24.31                                     0.3    221 264 
 SHB  SZ EPn  0   1237 27.99                                     0.0    254 279 
 MRD  SZ EPn  0   1237 28.80                                     0.3    258 291 
 BST  SN ELg  0   1237 29.38                                    -0.0    143 261 
 AZR  SE ELg  0   1237 51.43                                     0.0    221 264 
 
 2006 0101 1316 22.9 L  34.933  46.292  2.0  Teh  4 0.3 2.2LTeh                1 
 GAP=290                                                                       E 
 Iranian Seismological Center, Institute of Geophysics, University of Tehran   6 
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO SNR AR TRES  W DIS CAZ7 
 GHG  SZ E    0   1316 44.78      2607.6 0.06                          72.0 159 
 LIN  SZ E    0   1316 42.60      2426.4 0.08                          61.0  91 
 DHR  SZ E    0   1316 30.90    108786.0 0.04                          27.0 161 
 KOM  SZ E    0   1317  7.20       713.4 0.18                           140 126 
 DHR  SZ EPg  0   1316 27.32                                    -0.1   27.0 161 
 DHR  SN ESg  0   1316 30.52                                     0.0   27.0 161 
 LIN  SZ EPg  0   1316 32.78                                    -0.1   61.0  91 
 GHG  SZ EPg  0   1316 34.96                                     0.4   72.0 159 
 LIN  SN ESg  0   1316 40.32                                     0.0   61.0  91 
 KOM  SZ EPg  0   1316 45.20                                    -0.4    140 126

[out_file] after do your script:
Code:
GAP=238 ? ? ?  ? 20060101  
Iranian ? ? ? enter, ? 20060101 of Geophysics,
STAT ? ? ? PHASW ? 20060101 HRMM SECON
HSH ? ? ?  ? 20060101 1237 29.15
AZR ? ? ?  ? 20060101 1237 58.33
MRD ? ? ?  ? 20060101 1238 5.28
BST ? ? ?  ? 20060101 1237 31.34
SHB ? ? ?  ? 20060101 1238 2.03
AZR ? ? ? Pn ? 20060101 1236 40.89
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
AZR ? ? ? Pn ? 20060101 1237 24.31
SHB ? ? ? Pn ? 20060101 1237 27.99
MRD ? ? ? Pn ? 20060101 1237 28.80
BST ? ? ? Lg ? 20060101 1237 29.38
AZR ? ? ? Lg ? 20060101 1237 51.43
  ? ? ?  ? 20060101  
GAP=290 ? ? ?  ? 20060101  
Iranian ? ? ? enter, ? 20060101 of Geophysics,
STAT ? ? ? PHASW ? 20060101 HRMM SECON
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60
DHR ? ? ?  ? 20060101 1316 30.90
KOM ? ? ?  ? 20060101 1317 7.20
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96
LIN ? ? ? Sg ? 20060101 1316 40.32
KOM ? ? ? Pg ? 20060101 1316 45.20

and i want this file
[desired]
Code:
HSH ? ? ?  ? 20060101 1237 29.15
AZR ? ? ?  ? 20060101 1237 58.33
MRD ? ? ?  ? 20060101 1238 5.28
BST ? ? ?  ? 20060101 1237 31.34
SHB ? ? ?  ? 20060101 1238 2.03
AZR ? ? ? Pn ? 20060101 1236 40.89
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
AZR ? ? ? Pn ? 20060101 1237 24.31
SHB ? ? ? Pn ? 20060101 1237 27.99
MRD ? ? ? Pn ? 20060101 1237 28.80
BST ? ? ? Lg ? 20060101 1237 29.38
AZR ? ? ? Lg ? 20060101 1237 51.43
  
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60
DHR ? ? ?  ? 20060101 1316 30.90
KOM ? ? ?  ? 20060101 1317 7.20
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96
LIN ? ? ? Sg ? 20060101 1316 40.32
KOM ? ? ? Pg ? 20060101 1316 45.20

# 14  
Old 05-08-2012
Quote:
Originally Posted by oreka18
but my input file and output file are?
[orginal_file]
Code:
2006 0101 1236 49.3 L  37.902  48.482  0.0  Teh  5 0.2 2.7LTeh                1 
 GAP=238                                                                       E 
 Iranian Seismological Center, Institute of Geophysics, University of Tehran   6 
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO SNR AR TRES  W DIS CAZ7 
 HSH  SZ E    0   1237 29.15      2843.4 0.04                           126 238 
 AZR  SZ E    0   1237 58.33       598.9 0.14                           221 264 
 MRD  SZ E    0   1238  5.28       615.6 0.22                           258 291 
 BST  SZ E    0   1237 31.34       897.3 0.08                           143 261 
 SHB  SZ E    0   1238  2.03       222.2 0.16                           254 279 
 AZR  SE EPn  0   1236 40.89                                     0.0    0.0   0 
 BST  SN EPn  0   1236 45.64                                     0.0    0.0   0 
 HSH  SZ EPg  0   1237 9.75                                     -0.0    126 238 
 BST  SZ EPn  4   1237 10.80                                    -3.6    143 261 
 AZR  SZ EPn  0   1237 24.31                                     0.3    221 264 
 SHB  SZ EPn  0   1237 27.99                                     0.0    254 279 
 MRD  SZ EPn  0   1237 28.80                                     0.3    258 291 
 BST  SN ELg  0   1237 29.38                                    -0.0    143 261 
 AZR  SE ELg  0   1237 51.43                                     0.0    221 264 
 
 2006 0101 1316 22.9 L  34.933  46.292  2.0  Teh  4 0.3 2.2LTeh                1 
 GAP=290                                                                       E 
 Iranian Seismological Center, Institute of Geophysics, University of Tehran   6 
 STAT SP IPHASW D HRMM SECON CODA AMPLIT PERI AZIMU VELO SNR AR TRES  W DIS CAZ7 
 GHG  SZ E    0   1316 44.78      2607.6 0.06                          72.0 159 
 LIN  SZ E    0   1316 42.60      2426.4 0.08                          61.0  91 
 DHR  SZ E    0   1316 30.90    108786.0 0.04                          27.0 161 
 KOM  SZ E    0   1317  7.20       713.4 0.18                           140 126 
 DHR  SZ EPg  0   1316 27.32                                    -0.1   27.0 161 
 DHR  SN ESg  0   1316 30.52                                     0.0   27.0 161 
 LIN  SZ EPg  0   1316 32.78                                    -0.1   61.0  91 
 GHG  SZ EPg  0   1316 34.96                                     0.4   72.0 159 
 LIN  SN ESg  0   1316 40.32                                     0.0   61.0  91 
 KOM  SZ EPg  0   1316 45.20                                    -0.4    140 126

[out_file] after do your script:
Code:
GAP=238 ? ? ?  ? 20060101  
Iranian ? ? ? enter, ? 20060101 of Geophysics,
STAT ? ? ? PHASW ? 20060101 HRMM SECON
HSH ? ? ?  ? 20060101 1237 29.15
AZR ? ? ?  ? 20060101 1237 58.33
MRD ? ? ?  ? 20060101 1238 5.28
BST ? ? ?  ? 20060101 1237 31.34
SHB ? ? ?  ? 20060101 1238 2.03
AZR ? ? ? Pn ? 20060101 1236 40.89
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
AZR ? ? ? Pn ? 20060101 1237 24.31
SHB ? ? ? Pn ? 20060101 1237 27.99
MRD ? ? ? Pn ? 20060101 1237 28.80
BST ? ? ? Lg ? 20060101 1237 29.38
AZR ? ? ? Lg ? 20060101 1237 51.43
  ? ? ?  ? 20060101  
GAP=290 ? ? ?  ? 20060101  
Iranian ? ? ? enter, ? 20060101 of Geophysics,
STAT ? ? ? PHASW ? 20060101 HRMM SECON
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60
DHR ? ? ?  ? 20060101 1316 30.90
KOM ? ? ?  ? 20060101 1317 7.20
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96
LIN ? ? ? Sg ? 20060101 1316 40.32
KOM ? ? ? Pg ? 20060101 1316 45.20

and i want this file
[desired]
Code:
HSH ? ? ?  ? 20060101 1237 29.15
AZR ? ? ?  ? 20060101 1237 58.33
MRD ? ? ?  ? 20060101 1238 5.28
BST ? ? ?  ? 20060101 1237 31.34
SHB ? ? ?  ? 20060101 1238 2.03
AZR ? ? ? Pn ? 20060101 1236 40.89
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
AZR ? ? ? Pn ? 20060101 1237 24.31
SHB ? ? ? Pn ? 20060101 1237 27.99
MRD ? ? ? Pn ? 20060101 1237 28.80
BST ? ? ? Lg ? 20060101 1237 29.38
AZR ? ? ? Lg ? 20060101 1237 51.43
  
GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60
DHR ? ? ?  ? 20060101 1316 30.90
KOM ? ? ?  ? 20060101 1317 7.20
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96
LIN ? ? ? Sg ? 20060101 1316 40.32
KOM ? ? ? Pg ? 20060101 1316 45.20

Code:
# awk '/^ *200?/{x=$1$2;y="? ? ?";while($1!~/STAT/)getline;next}!/^ *$/{sub(/^./,"",$3);print $1,y,$3,"?",x,$5,$6;}/^ *$/{print}' input
HSH ? ? ?  ? 20060101 1237 29.15
AZR ? ? ?  ? 20060101 1237 58.33
MRD ? ? ?  ? 20060101 1238 5.28
BST ? ? ?  ? 20060101 1237 31.34
SHB ? ? ?  ? 20060101 1238 2.03
AZR ? ? ? Pn ? 20060101 1236 40.89
BST ? ? ? Pn ? 20060101 1236 45.64
HSH ? ? ? Pg ? 20060101 1237 9.75
BST ? ? ? Pn ? 20060101 1237 10.80
AZR ? ? ? Pn ? 20060101 1237 24.31
SHB ? ? ? Pn ? 20060101 1237 27.99
MRD ? ? ? Pn ? 20060101 1237 28.80
BST ? ? ? Lg ? 20060101 1237 29.38
AZR ? ? ? Lg ? 20060101 1237 51.43

GHG ? ? ?  ? 20060101 1316 44.78
LIN ? ? ?  ? 20060101 1316 42.60
DHR ? ? ?  ? 20060101 1316 30.90
KOM ? ? ?  ? 20060101 1317 7.20
DHR ? ? ? Pg ? 20060101 1316 27.32
DHR ? ? ? Sg ? 20060101 1316 30.52
LIN ? ? ? Pg ? 20060101 1316 32.78
GHG ? ? ? Pg ? 20060101 1316 34.96
LIN ? ? ? Sg ? 20060101 1316 40.32
KOM ? ? ? Pg ? 20060101 1316 45.20

regards
ygemici
This User Gave Thanks to ygemici For This Post:
oreka18
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command/script to match a field and print the next field of each line in a file.

Hello, I have a text file in the below format: Source Destination State Lag Status CQA02W2K12pl:D:\CAQA ... (10 Replies)
Discussion started by: pocodot
10 Replies

2. Red Hat

Remove new line for a particular place

Hello All, I have a text file which gets uploaded to tables using shells script. However before running that script I need to alter it, like in the below I have to firstly find the word 1234 and remove the new line from end of it. 1234,5678,fasfasasfsadf abc changes to... (11 Replies)
Discussion started by: Sandeep_sandy
11 Replies

3. Shell Programming and Scripting

Add line in exact place

I have one big XML file which contains information about 100 jobs,"JOB JOBISN=" indicates that is a job so where ever tag starts with "JOB JOBISN=" then i need to add below highlighted line between "<INCOND NAME" and "<OUTCOND NAME" for all jobs.like this i want to add below highlighted line for... (7 Replies)
Discussion started by: katakamvivek
7 Replies

4. Shell Programming and Scripting

awk to place value at 24 field in a flat file issue

I am trying to add 0393 value at 24th feild using the below command, but its adding at all the lines including header and trailer Input file: ZHV|2657|D0217001|T|TXU|Z|PAN|20131112000552||||OPER| 754|52479| 492|489|SP40|1014570286334|20131111|20131201|14355334|CHAMELON... (1 Reply)
Discussion started by: Aditya_001
1 Replies

5. Shell Programming and Scripting

How to update field value in place?

Dear all: I have a file: 1:00 2:abc 3:12asweand I ran the following awk script on this file: #!/usr/bin/awk -f { i= 1; while(i<=NF) { $i=substr($i, 1, index($i, ":")-1); i++ } }I am expecting the file would become (after running... (7 Replies)
Discussion started by: littlewenwen
7 Replies

6. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

7. UNIX for Dummies Questions & Answers

using gsed with cp to sort files in directory - every N file copy to new place

Hi all, I'm having a problem with some basic piping issues... I have been able to get in a directory and ls | gsed in order to list every N file for instance: ls | gsed -n '2~5p' The thing is I want to be able to copy the output files to a new directory. Basically directory /all has a... (4 Replies)
Discussion started by: dgoss
4 Replies

8. UNIX for Dummies Questions & Answers

Copy dir/file from one place to another.

Hello all. I'm not getting the hang of Paths. I have a dir w/files that I want to copy to another dir. Right now I am in the "source" directory. I want to copy it to Ch7. "cp -r source Ch7". Ch7 was already created. 1st msg.: cannot stat `source`: No such file or dir. I typed pwd & got... (3 Replies)
Discussion started by: Ccccc
3 Replies

9. Solaris

What is the best way to copy data from place to another place?

Dear Gurus, I need you to advice or suggestion about the best solution to copy data around 200-300G from serverA(location A) to serverB(location B). Normally, I will share folder and then copy but it takes too long time(about 2 days). Do you have any suggestion or which way should be... (9 Replies)
Discussion started by: unitipon
9 Replies

10. Shell Programming and Scripting

Getting the value of a line, that changes place

Hi I am trying to get the value of several results in a file called seq032.diag. The values I am looking for is down under Smooth Tracking nodes and is for g01r01 g02r01 s01t02 etc etc. The problem is that when I try to use look for text and tail etc, it works fine in one result file. In... (1 Reply)
Discussion started by: Navigatorchief
1 Replies
Login or Register to Ask a Question