topic Re: Shell script Query in Operating System - HP-UX

Shell script Query

Amith_2 — Mon, 12 Mar 2007 09:26:58 GMT

Hello,

I want to replace the value “99” which is in 79th position of a data file to spaces. Can any one help me how to achieve this in a script. It should be done only if the value is 99.

Regards
Amith

Re: Shell script Query

A. Clay Stephenson — Mon, 12 Mar 2007 09:31:33 GMT

Are the data line-oriented? (i.e each record terminated with a LF or LF/CR pair or is each record fixed-length with no separator. Is this a pure textfile containing no binary data. When you define the problem more precisely, the solutions often are obvious.

Re: Shell script Query

Geoff Wild — Mon, 12 Mar 2007 09:41:49 GMT

As Clay says - we need to know the format of the file...

You could try:

cat yourfile | sed 's/99/ /g' > newfile

Rgds...Geoff

Re: Shell script Query

James R. Ferguson — Mon, 12 Mar 2007 09:48:13 GMT

Hi Amith:

*IF* you have an Ascii text file, then the following will replace the string of "99" with spaces _only_ when it is in the 79th position (counting the first character as *zero*):

# perl -ple 'substr($_,79,2," ") if substr($_,79,2)==99' file

If you count the 79th position from character one, then change the 79-to-78.

Regards!

...JRF...

Re: Shell script Query

Dennis Handly — Mon, 12 Mar 2007 23:03:28 GMT

An awk solution would be:
awk '{
if (substr($0, 79, 2) == "99") {
$0 = substr($0,1,78) " " substr($0,81)
}
print
}'

awk allows access to positions beyond the end of a string and returns null. (awk's substr counts from 1.)

Re: Shell script Query

Amith_2 — Tue, 13 Mar 2007 02:11:35 GMT

I am attaching the file which contains a record and i need to change the value 99 starting from 79th position to spaces.
I tried the commands but none is working

Re: Shell script Query

Dennis Handly — Tue, 13 Mar 2007 03:03:19 GMT

>I am attaching the file which contains a record and i need to change the value 99 starting from 79th position to spaces.

It works according to what you said and we guessed. How do you number to 79th position? (JRF asked) Start from 1 or 0? I assumed 1 and the length was just 2.
...4999990...
...499 90...

(Note: My script make a copy to stdout with the changes.)