Line replacement

[job357]

Hello,
I have a file that has a line that i need to replace, the line is as follows exactly:

"e641",, 20030101, 20030101, "043900", "ERR"^M

I need this line replaced with:

"e641",,,,"",""

Thanks,
Travis

 

[PHV]

Try this:

awk -F, '
$6=="ERR"{printf "%s,,,,\"\",\"\"",$1;next}
{print}
' <InputFile >OutputFile

Hope This Help
PH.

 

[job357]

Thanks,
I am going to try this and let you know, thanks again.

 

[job357]

Sorry,
But I am getting an error when running this command againt the file:

Usage: awk [POSIX or GNU style options] -f progfile [--] file ...
awk [POSIX or GNU style options] [--] 'program' file ...
POSIX options: GNU long options:

As if the syntax is incorrect?

 

[dickiebird]

Works for me on Aix 4 ( and on 3.25)
Have you got nawk or gawk - try that instead
NB - I included a \n in the printf template

awk -F, '
$6=="ERR"{printf "%s,,,,\"\",\"\"\n",$1;next}
{print}
' InputFile >OutputFile

Dickie Bird (-)))

 

[PHV]

Try this:

awk 'BEGIN{FS=","}
$6=="ERR"{printf "%s,,,,\"\",\"\"\n",$1;next}
{print}
' <InputFile >OutputFile

Thanks dickiebird for the correction.

Hope This Help
PH.