How to find and delete row in file

[bosoxer1]

I currently use the below script to modify a file, but I have to find a string starting in postion 37, like "19012", and delete that row, and continue with the rest of the script.

How do I NOT print that row out?

1==NR { print; next }
NR>2 { print fix(line) }
{line = $0}
END { print line }
function fix( s )
{ if (" "==substr(s,col,1) )
s = substr(s,1,col-1) "3" substr(s,col+1)
return s
}

 

[PHV]

Something like this ?
substr($0,37,5)=="19012"{next}

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bosoxer1]

Great...I have the format, but should it be wrapped inside an if statement? I actually have to strings to look for and by pass...

substr($0,1,42)=="0000671960595 19012" {next}
substr($0,1,36)=="99994661 " {next}

Should they go before the function call?

 

[Annihilannic]

They should go before this line:

[tt]NR>2 { print fix(line) }[/tt]

Every line of an awk programme contains an implicit if statement. Taking the above line as an example, you could read it like this:

[tt]if (NR > 2) then { print fix(line) }[/tt]

Annihilannic.