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
# 15  
Old 05-09-2012
thank you very much, now i want to print each line which the 5th field of that contains stings "*P,P*" or "*s,S*" {P,S,Pg,Sg,Pn,Sn} without losing blank lines.

# 16  
Old 05-09-2012
Quote:
Originally Posted by oreka18
thank you very much, now i want to print each line which the 5th field of that contains stings "*P,P*" or "*s,S*" {P,S,Pg,Sg,Pn,Sn} without losing blank lines.

i suppose that you meant the $3 coloumn (contains -> EPg,ESg) ?
Code:
#  awk --posix '{if(!/^ *$/){if($3~/EP[ng]{0,1}$/||$3~/ES[ng]{0,1}$/)print}else print}' yourfile

This User Gave Thanks to ygemici For This Post:
oreka18
# 17  
Old 05-09-2012
thanks but there is no output! did you test it on the data that i leaved on previews section?
# 18  
Old 05-09-2012
Quote:
Originally Posted by oreka18
thanks but there is no output! did you test it on the data that i leaved on previews section?
Code:
# cat /etc/redhat-release
Fedora release 14 (Laughlin)

Code:
# cat yourfile
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

Code:
# awk --posix '{if(!/^ *$/){if($3~/EP[ng]{0,1}$/||$3~/ES[ng]{0,1}$/)print}else print}' yourfile
 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

 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
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