Awk script - need to append something to the end of a line if one
doesn't already exist.

Example:

DOMAIN TYPE RECORD
DOMAI1 TYPE RECORD.ONE.
DOMAI2 TYPE RECORD.TWO.
DOMAI3 TYPE RECORD
DOMAI4 TYPE RECORD.THREE

needs to become:

DOMAIN TYPE RECORD.NEW.
DOMAI1 TYPE RECORD.ONE.
DOMAI2 TYPE RECORD.TWO.
DOMAI3 TYPE RECORD.NEW.
DOMAI4 TYPE RECORD.THREE

Basically appending .NEW. to the end of each line that does not end in
a period and a newline char.

I'd like to get this done with an AWK command - and I am using files
that are 1-2gb a piece.

---

Clarification of Question by samuelnorris-ga on 23 Sep 2003 23:14 PDT

Yes, I did mistype the last line. . .  It should have ended up with a
.NEW. as well.

Thanks - I think that did it, I just couldn't get the syntax right on
the replace command.  Here is what I ended up with:

sed -e 's/[^\.]$/.NET./g' -e 's/ NS /.NET NS /g' net.dat | awk
'{fname="net." substr($0,1,1) ".dat"; print $0 > fname}'

I used sed for the replacement ( 2 replacements per line usually ) and
then awk to split the file into many files.  The data file is 1gb in
size and to perform tasks its easier to split it by the first letter
of each line.

Awesome, thanks!

[Your example doesn't follow your rule. By your rule the final line
ending in .THREE should have a .NEW. appended. I'm assuming your rule
is correct and you missed the trailing period in the example.]

Anyway, I'm no AWK expert, but at least on my WinXP machine the
following program works:

BEGIN {}
/\.$/    {print $0;}          # match lines ending in a period
/[^\.]$/ {print $0".NEW.";}   # match lines that don't end in a period
END {}

If you save this in a file called append.awk, and your data is in
records.dat, then you'd run the following command:

> awk -f append.awk records.dat > new_records.dat

I found the following AWK tutorials to be quite helpful:

http://www.canberra.edu.au/~sam/whp/awk-guide.html

http://www.vectorsite.net/tsawk1.html

http://www.gnu.org/manual/gawk-3.1.1/html_node/index.html

Once you've grasped the basic structure of an AWK program it all comes
down to learning how to construct the correct regular expression,
which can be often be challenging.

Hope this helps.

Cheers,

Eadfrith

so how does this work - can you put that reply in as an answer and
then it will pay you the money?  I'd like to give it to you since you
really did solve my question.

Thanks,
Sam

Well, I'm not a researcher, so this one's on the house.

Glad you got the solution you wanted.

Cheers,

Eadfrith