The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
script for a 3 line paragraph invinzin21 Shell Programming and Scripting 2 12-17-2007 09:11 PM
Appending a line in a file after a particular line maxvirrozeito Shell Programming and Scripting 7 12-12-2007 09:58 AM
Appending line ending with '}" to new line aismann Shell Programming and Scripting 4 08-12-2007 11:09 PM
Appending the line number and a seperator to each line of a file ? pjcwhite Shell Programming and Scripting 4 03-20-2007 09:29 PM
Convert a paragraph to single line rimss Shell Programming and Scripting 6 06-07-2006 12:17 PM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-27-2007
Registered User
 

Join Date: Apr 2007
Posts: 4
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Question SED or AWK: Appending a line Identifier that changes with paragraph?

Have another question that has been eluding me all day.

I have data file I'm trying to reformat so that each line is appended with an ID code, but the ID code needs to update as it searches through the file.

I.e.


----Begin Original Datafile-----
Condition = XXX

Header Line 1
Header Line 2

Station Data
1 5.43
2 6.43
3 7.8
4 450
5 650

Condition = YYY

Header Line 1
Header Line 2

Station Data
1 654
2 987
3 875
4 874
5 678

Condition= ZZZ
ZZZ
.
.
.
.
----------End Data File-----------


and I would like to convert it to


--------Begin Desired Datafile ------
Condition = XXX
XXX
Header Line 1 XXX
Header Line 2 XXX
XXX
Station Data XXX
1 5.43 XXX
2 6.43 XXX
3 7.80 XXX
4 4500 XXX
5 6506 XXX
XXX
Condition = YYY
YYY
Header Line 1 YYY
Header Line 2 YYY
YYY
Station Data YYY
1 654 YYY
2 987 YYY
3 875 YYY
4 874 YYY
5 678 YYY
YYY
Condition= ZZZ
ZZZ
.
.
.
------End Desired Datafile ------

With possibly several thousand unique Condition ID's and datasets. There are also some blank and header lines before each data set and appending the line identifier to those is just fine. All the blank and header lines are already being deleted at a later step.

If it were just a few cases I could hard code it, but having the condition ID update as it goes is beyond me at the moment.

Thanks in advance! So far you all have been extremely helpful and I'll definitely be back.
Cheers
Josh
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 04-27-2007
Registered User
 

Join Date: Sep 2006
Posts: 1,403
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Code:
awk ' BEGIN{FS="= "} 
      /Condition/ {cond = $2 ; print $0    ;next}
      /^$/ { print cond ; next}
      {print $0 " " cond}
    ' "file"
output:
Code:
# ./test.sh
Condition = XXX
XXX
Header Line 1 XXX
Header Line 2 XXX
XXX
Station Data XXX
1 5.43 XXX
2 6.43 XXX
3 7.8 XXX
4 450 XXX
5 650 XXX
XXX
Condition = YYY
YYY
Header Line 1 YYY
Header Line 2 YYY
YYY
Station Data YYY
1 654 YYY
2 987 YYY
3 875 YYY
4 874 YYY
5 678 YYY
YYY
Condition= ZZZ
ZZZ ZZZ
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes


The 50 most popular UNIX and Linux searches.
Google Search Cloud for The UNIX and Linux Forums
421 service not available, remote server has closed connection ^m automate ftp autosys awk trim bash eval bash exec bash for loop command copy/move folder in unix couldn't set locale correctly curses.h cut command in unix export command in unix find grep find mtime find null character in a unix file grep multiple lines grep or grep recursive hp-ux ifconfig inaddr_any inappropriate ioctl for device lynx javascript mailx attachment mget mtime ping port remove first character from string in k shell replace space by comma , perl script rsync ftp scp recursive segmentation fault(coredump) sftp script snoop unix solaris change ip address stale nfs file handle syn_sent tar exclude tar extract to folder test: argument expected unix unix .profile unix forum unix forums unix internals unix mtime unix simulator unix.com vi substitute while loop within while loop shell script


All times are GMT -7. The time now is 03:36 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101