topic sed or awk challenge in Operating System - HP-UX

sed or awk challenge

Rene Krewinkel — Wed, 14 Nov 2001 11:44:32 GMT

Hi,

I have the following 'challenge':
- a 3rd party program reads the data in an ascii file until it finds a trailer record with the last word being "EOF".
- the program doesnot accept any characters or lines after this "EOF" marker. So the string EOF has to be followed by the actual EOF-code.
- The data for this file is spooled by the oracle utl_file package, so every written line in a text file is terminated with a line-feed/cariage return character.
- My question: does any one have a clue on how to replace the "EOF" string with the "EOF"string combined with the EOF character??
thanx in advance...

Re: sed or awk challenge

Robin Wakefield — Wed, 14 Nov 2001 11:51:15 GMT

Hi Rene,

So if your file, /tmp/abc, contains:

this is a line
so is this
and this
this is the end EOF
should not get here
or here

is this what you require?:

awk '/EOF/{print;exit}{print}' /tmp/abc
this is a line
so is this
and this
this is the end EOF

Rgds, Robin.

Re: sed or awk challenge

Bill McNAMARA_1 — Wed, 14 Nov 2001 11:55:10 GMT

There could only be one person to do that!

you da man Robin!!

Bill

Re: sed or awk challenge

Rene Krewinkel — Wed, 14 Nov 2001 11:59:23 GMT

Sorry Robin, thanx for the reponse tough,
but if I transfer the file (binary or ascii) doesn't matter to a NT environment, there is still a new-line char after the EOF statement...

Re: sed or awk challenge

Robin Wakefield — Wed, 14 Nov 2001 12:05:52 GMT

Hi Rene,

sorry, try this:

awk '/EOF/{printf"%s",$0;exit}{print}' /tmp/abc

Rgds, Robin.

Re: sed or awk challenge

Marco Paganini — Wed, 14 Nov 2001 16:51:31 GMT

Hello,

I'd suggest just a small change on Robin's solution.

If you feed something like:

this is a line
so is this
and this
this is a false EOF folks...
this is the end EOF
should not get here

to the previous script, it will fail (EOF is there, but it is not the last word). A solution would be:

awk '/EOF[ \t]*$/{printf"%s",$0;exit}{print}'

Hope it helps,
Paga

Re: sed or awk challenge

Krishna Prasad — Thu, 15 Nov 2001 18:16:40 GMT

If you are moving the file from Unix to NT and then accessing it in NT I believe you will always have a new line character becuase of the way each operating system saves files.

If you use vi to look at the file you see a ^M at the end of everyline. You can strip the control M on the Unix box if it came from NT.
However, I think you will have to have some kind of utility on the NT box that will give you an Unix shell to stripe the control M.

on the Unix side you can do something like

cat filename | sed 's/^M///g' > newfilename

the ^ is actually the control character not just a shift 6 you need to hit the control key.

Let me know if this is what you are asking?

Re: sed or awk challenge

Rene Krewinkel — Fri, 16 Nov 2001 08:29:01 GMT

Thanx guy's,

Marco's solution seems to do the trick after all. I MUST transfer the file binary though!

regards,

Rene