Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [awk] find pattern, change next two lines
Top Forums Shell Programming and Scripting [awk] find pattern, change next two lines Post 302897744 by origamisven on Tuesday 15th of April 2014 04:52:08 PM
Old 04-15-2014
[awk] find pattern, change next two lines
Hi, hope you can help me... It seems like a straightforward problem, but I haven't had any success so far using my basic scripting and awk "skills":

I need to find a pattern /VEL/ in an input file that looks like this:

Code:
 1110SOL     OW25489   1.907   7.816  26.338 -0.4365  0.4100 -0.0736
 1110SOL    HW125490   1.890   7.829  26.435  0.3507  0.4216  0.0705
 1110SOL    HW225491   1.945   7.724  26.323  0.0656  0.6460 -0.2797
 1111VEL     OW25492   4.172   7.242   6.227  0.4897 -1.0759  0.7407
 1111SOL    HW125493   4.231   7.300   6.284 -1.1002 -0.8260  1.3902
 1111SOL    HW225494   4.076   7.266   6.243 -0.8879 -1.4622  1.1007
 1112SOL     OW25495   0.578   1.347  21.833 -0.3603 -0.4613 -0.2495
 1112SOL    HW125496   0.550   1.375  21.741 -0.2047  1.9848  0.3727
 1112SOL    HW225497   0.506   1.291  21.874 -0.7886 -0.8859 -1.5335

...and then replace the SOL in the following two lines with VEL, so it looks like this:

Code:
 1110SOL     OW25489   1.907   7.816  26.338 -0.4365  0.4100 -0.0736
 1110SOL    HW125490   1.890   7.829  26.435  0.3507  0.4216  0.0705
 1110SOL    HW225491   1.945   7.724  26.323  0.0656  0.6460 -0.2797
 1111VEL     OW25492   4.172   7.242   6.227  0.4897 -1.0759  0.7407
 1111VEL    HW125493   4.231   7.300   6.284 -1.1002 -0.8260  1.3902
 1111VEL    HW225494   4.076   7.266   6.243 -0.8879 -1.4622  1.1007
 1112SOL     OW25495   0.578   1.347  21.833 -0.3603 -0.4613 -0.2495
 1112SOL    HW125496   0.550   1.375  21.741 -0.2047  1.9848  0.3727
 1112SOL    HW225497   0.506   1.291  21.874 -0.7886 -0.8859 -1.5335

Thanks for any help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find required files by pattern in xml files and the change the pattern on Linux

Hello, I need to find all *.xml files that matched by pattern on Linux. I need to have written the file name on the screen and then change the pattern in the file just was found. For instance. I can start the script with arguments for keyword and for value, i.e script.sh keyword... (1 Reply)
Discussion started by: yart
1 Replies

2. Shell Programming and Scripting

awk to find pattern and add lines

My file goes like this: SID_LIST_HOSTNAME_LISTENER_3 = (SID_LIST = (SID_DESC = (SID_NAME = ORA0008) (ORACLE_HOME = /opt/oracle/product/ORA0008) (ENVS = "LD_LIBRARY_PATH=/opt/oracle/product/ORA0008/lib") ) (SID_DESC = (SID_NAME = ORA0007) ... (4 Replies)
Discussion started by: jpsingh
4 Replies

3. Shell Programming and Scripting

Find and change the lines in the file.

Hi Everyone, I have a JIL (Job Information Language) Definition for Several Jobs in a file. I would like to do the following: insert_job: KS_INT_BIZ_INT job_type: c command: /home/filter/script.sh INT machine: MACHINE owner: filter permission: gx,mx date_conditions: 1 days_of_week:... (3 Replies)
Discussion started by: filter
3 Replies

4. Shell Programming and Scripting

how to find pattern and discard lines before it?

Hi all, I'd like to search a file for the first occurence of the phrase "PLASTICS THAT EXPIRE" and then discard all the lines that came before it. Output the remainder to a new file. Operating system is hp-ux. I've searched for usual awk and sed one liners but can't find a solution. Thank... (4 Replies)
Discussion started by: Scottie1954
4 Replies

5. Shell Programming and Scripting

sed -- Find pattern -- print remainder -- plus lines up to pattern -- Minus pattern

The intended result should be : PDF converters 'empty line' gpdftext and pdftotext?xml version="1.0"?> xml:space="preserve"><note-content version="0.1" xmlns:/tomboy/link" xmlns:size="http://beatniksoftware.com/tomboy/size">PDF converters gpdftext and pdftotext</note-content>... (9 Replies)
Discussion started by: Klasform
9 Replies

6. Shell Programming and Scripting

Using awk or sed to find a pattern that has lines before and after it

Dear gurus, Please help this beginner to write and understand the required script. I am looking for useing awk for sed. I have a few thousand lines file whose contain are mostly as below and I am trying to achieve followings. 1. Find a string, say user1. Then hash the line containing the... (6 Replies)
Discussion started by: ran_bon_78
6 Replies

7. Shell Programming and Scripting

Find pattern; grep n lines before and after

Hi, I need help to grep a specific part of a log file (bold). 24/2/2017-16:57:17.056 frosti-1 M3UA-Tx: } 24/2/2017-16:57:17.056 frosti-1 M3UA-Tx: extensionContainer <Not Present> 24/2/2017-16:57:17.056... (8 Replies)
Discussion started by: vasil
8 Replies

8. UNIX for Beginners Questions & Answers

find pattern matches in consecutive lines in certain fields-awk

I have a text file with many thousands of lines, a small sample of which looks like this: InputFile:PS002,003 D -1 5 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 6 -1 -1 -1 -1 0 509 0 PS002,003 PSQ 0 1 7 18 1 0 -1 1 1 3 -1 -1 ... (5 Replies)
Discussion started by: jvoot
5 Replies

9. Shell Programming and Scripting

Find specific pattern and change some of block values using awk

Hi, Could you please help me finding a way to replace a specific value in a text block when matching a key pattern ? I got the keys and the values from a command similar to: echo -e "key01 Nvalue01-1 Nvalue01-2 Nvalue01-3\nkey02 Nvalue02-1 Nvalue02-2 Nvalue02-3 \nkey03 Nvalue03-1... (2 Replies)
Discussion started by: alex2005
2 Replies

10. UNIX for Beginners Questions & Answers

awk to remove pattern and lines above pattern

In the awk below I am trying to remove all lines above and including the pattern Test or Test2. Each block is seperated by a newline and Test2 also appears in the lines to keep but it will always have additional text after it. The Test to remove will not. The awk executed until the || was added... (2 Replies)
Discussion started by: cmccabe
2 Replies

LEARN ABOUT OPENSOLARIS

iconv_1251

iconv_1251(5)						Standards, Environments, and Macros					     iconv_1251(5)

NAME

       iconv_1251 - code set conversion tables for MS 1251 (Windows Cyrillic)

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |		     Code Set Conversions Supported			 |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output	 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |KOI8-R	      |koi8    | KOI8-R 		 |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |MS 1251       |win5    |Mac Cyrillic  |mac     | Macintosh Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 1251 to ISO 8859-5
       For the conversion of MS 1251 to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |  ISO 8859-5	|   MS 1251	 |  ISO 8859-5	 |
       |24	       | 4		|310		 |270		 |
       |200	       | 242		|311		 |271		 |
       |201	       | 243		|312		 |272		 |
       |202	       | 40		|313		 |273		 |
       |203	       | 363		|314		 |274		 |
       |204-207        | 40		|315		 |275		 |
       |210	       | 255		|316		 |276		 |
       |211	       | 40		|317		 |277		 |
       |212	       | 251		|320		 |300		 |
       |213	       | 40		|321		 |301		 |
       |214	       | 252		|322		 |302		 |
       |215	       | 254		|323		 |303		 |
       |216	       | 253		|324		 |304		 |
       |217	       | 257		|325		 |305		 |
       |220	       | 362		|326		 |306		 |
       |221-227        | 40		|327		 |307		 |
       |230	       | 255		|330		 |310		 |
       |231	       | 40		|331		 |311		 |
       |232	       | 371		|332		 |312		 |
       |233	       | 40		|333		 |313		 |
       |234	       | 372		|334		 |314		 |
       |235	       | 374		|335		 |315		 |
       |236	       | 373		|336		 |316		 |
       |237	       | 377		|337		 |317		 |
       |241	       | 256		|340		 |320		 |
       |242	       | 376		|341		 |321		 |
       |243	       | 250		|342		 |322		 |
       |244-247        | 40		|343		 |323		 |
       |250	       | 241		|344		 |324		 |
       |251	       | 40		|345		 |325		 |
       |252	       | 244		|346		 |326		 |
       |253-254        | 40		|347		 |327		 |
       |255	       | 55		|350		 |330		 |
       |256	       | 40		|351		 |331		 |
       |257	       | 247		|352		 |332		 |
       |260-261        | 40		|353		 |333		 |
       |262	       | 246		|354		 |334		 |
       |263	       | 366		|355		 |335		 |
       |264-267        | 40		|356		 |336		 |
       |270	       | 361		|357		 |337		 |
       |271	       | 360		|360		 |340		 |
       |272	       | 364		|361		 |341		 |
       |273	       | 40		|362		 |342		 |
       |274	       | 370		|363		 |343		 |
       |275	       | 245		|364		 |344		 |
       |276	       | 365		|365		 |345		 |
       |277	       | 367		|366		 |346		 |
       |300	       | 260		|367		 |347		 |
       |301	       | 261		|370		 |350		 |
       |302	       | 262		|371		 |351		 |
       |303	       | 263		|372		 |352		 |
       |304	       | 264		|373		 |353		 |
       |305	       | 265		|374		 |354		 |
       |306	       | 266		|375		 |355		 |
       |307	       | 267		|376		 |356		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to KOI8-R
       For the conversion of MS 1251 to KOI8-R , all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |    KOI8-R	|   MS 1251	 |   KOI8-R	 |
       |24	       | 4		|310		 |351		 |
       |200	       | 261		|311		 |352		 |
       |201	       | 262		|312		 |353		 |
       |202	       | 40		|313		 |354		 |
       |203	       | 242		|314		 |355		 |
       |204-207        | 40		|315		 |356		 |
       |210	       | 255		|316		 |357		 |
       |211	       | 40		|317		 |360		 |
       |212	       | 271		|320		 |362		 |
       |213	       | 40		|321		 |363		 |
       |214	       | 272		|322		 |364		 |
       |215	       | 274		|323		 |365		 |
       |216	       | 273		|324		 |346		 |
       |217	       | 277		|325		 |350		 |
       |220	       | 241		|326		 |343		 |
       |221-227        | 40		|327		 |376		 |
       |230	       | 255		|330		 |373		 |
       |231	       | 40		|331		 |375		 |
       |232	       | 251		|332		 |377		 |
       |233	       | 40		|333		 |371		 |
       |234	       | 252		|334		 |370		 |
       |235	       | 254		|335		 |374		 |
       |236	       | 253		|336		 |340		 |
       |237	       | 257		|337		 |361		 |
       |241	       | 276		|340		 |301		 |
       |242	       | 256		|341		 |302		 |
       |243	       | 270		|342		 |327		 |
       |244-247        | 40		|343		 |307		 |
       |250	       | 263		|344		 |304		 |
       |251	       | 40		|345		 |305		 |
       |252	       | 264		|346		 |326		 |
       |253-254        | 40		|347		 |332		 |
       |255	       | 55		|350		 |311		 |
       |256	       | 40		|351		 |312		 |
       |257	       | 267		|352		 |313		 |
       |260-261        | 40		|353		 |314		 |
       |262	       | 266		|354		 |315		 |
       |263	       | 246		|355		 |316		 |
       |264-267        | 40		|356		 |317		 |
       |270	       | 243		|357		 |320		 |
       |271	       | 260		|360		 |322		 |
       |272	       | 244		|361		 |323		 |
       |273	       | 40		|362		 |324		 |
       |274	       | 250		|363		 |325		 |
       |275	       | 265		|364		 |306		 |
       |276	       | 245		|365		 |310		 |
       |277	       | 247		|366		 |303		 |
       |300	       | 341		|367		 |336		 |
       |301	       | 342		|370		 |333		 |
       |302	       | 367		|371		 |335		 |
       |303	       | 347		|372		 |337		 |
       |304	       | 344		|373		 |331		 |
       |305	       | 345		|374		 |330		 |
       |306	       | 366		|375		 |334		 |
       |307	       | 372		|376		 |300		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to PC Cyrillic
       For the conversion of MS 1251 to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     |  PC Cyrillic	|   MS 1251	 | PC Cyrillic	 |
       |24	       | 4		|332		 |232		 |
       |200-207        | 40		|333		 |233		 |
       |210	       | 260		|334		 |234		 |
       |211-227        | 40		|335		 |235		 |
       |230	       | 260		|336		 |236		 |
       |231-247        | 40		|337		 |237		 |
       |250	       | 360		|340		 |240		 |
       |251-254        | 40		|341		 |241		 |
       |255	       | 55		|342		 |242		 |
       |256-267        | 40		|343		 |243		 |
       |270	       | 361		|344		 |244		 |
       |271-277        | 40		|345		 |245		 |
       |300	       | 200		|346		 |246		 |
       |301	       | 201		|347		 |247		 |
       |302	       | 202		|350		 |250		 |
       |303	       | 203		|351		 |251		 |
       |304	       | 204		|352		 |252		 |
       |305	       | 205		|353		 |253		 |
       |306	       | 206		|354		 |254		 |
       |307	       | 207		|355		 |255		 |
       |310	       | 210		|356		 |256		 |
       |311	       | 211		|357		 |257		 |
       |312	       | 212		|360		 |340		 |
       |313	       | 213		|361		 |341		 |
       |314	       | 214		|362		 |342		 |
       |315	       | 215		|363		 |343		 |
       |316	       | 216		|364		 |344		 |
       |317	       | 217		|365		 |345		 |
       |320	       | 220		|366		 |346		 |
       |321	       | 221		|367		 |347		 |
       |322	       | 222		|370		 |350		 |
       |323	       | 223		|371		 |351		 |
       |324	       | 224		|372		 |352		 |
       |325	       | 225		|373		 |353		 |
       |326	       | 226		|374		 |354		 |
       |327	       | 227		|375		 |355		 |
       |330	       | 230		|376		 |356		 |
       |331	       | 231		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 1251 to Mac Cyrillic
       For the conversion of MS 1251 to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1251     | Mac Cyrillic	|   MS 1251	 | Mac Cyrillic  |
       |24	       | 4		|260		 |241		 |
       |200	       | 253		|262		 |247		 |
       |201	       | 256		|263		 |264		 |
       |202	       | 40		|264		 |266		 |
       |203	       | 257		|266		 |246		 |
       |204	       | 327		|267		 |245		 |
       |205	       | 311		|270		 |336		 |
       |206	       | 240		|271		 |334		 |
       |207-211        | 40		|272		 |271		 |
       |212	       | 274		|273		 |310		 |
       |213	       | 40		|274		 |300		 |
       |214	       | 276		|275		 |301		 |
       |215	       | 315		|276		 |317		 |
       |216	       | 40		|277		 |273		 |
       |217	       | 332		|300		 |200		 |
       |220	       | 254		|301		 |201		 |
       |221	       | 324		|302		 |202		 |
       |222	       | 325		|303		 |203		 |
       |223	       | 322		|304		 |204		 |
       |224	       | 323		|305		 |205		 |
       |225	       | 40		|306		 |206		 |
       |226	       | 320		|307		 |207		 |
       |227	       | 321		|310		 |210		 |
       |230	       | 40		|311		 |211		 |
       |231	       | 252		|312		 |212		 |
       |232	       | 275		|313		 |213		 |
       |233	       | 40		|314		 |214		 |
       |234	       | 277		|315		 |215		 |
       |235	       | 316		|316		 |216		 |
       |236	       | 40		|317		 |217		 |
       |237	       | 333		|320		 |220		 |
       |240	       | 312		|321		 |221		 |
       |241	       | 330		|322		 |222		 |
       |242	       | 331		|323		 |223		 |
       |243	       | 267		|324		 |224		 |
       |244	       | 377		|325		 |225		 |
       |245	       | 242		|326		 |226		 |
       |246	       | 40		|327		 |227		 |
       |247	       | 244		|330		 |230		 |
       |250	       | 335		|331		 |231		 |
       |252	       | 270		|332		 |232		 |
       |253	       | 307		|333		 |233		 |
       |254	       | 302		|334		 |234		 |
       |255	       | 55		|335		 |235		 |
       |256	       | 250		|336		 |236		 |
       |257	       | 272		|337		 |237		 |
       |355	       | 316		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						     iconv_1251(5)
All times are GMT -4. The time now is 01:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy