hello.

I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this:

I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only [instead of YYYYMONDD date field expected] then replace it with a null/blank character.

I had a go at:

cat <datafile> | awk ‘$5 == “0” { “ “ } END { print }';
cat <datafile> | awk ‘$8 == “0” { “ “ } END { print }'; ..etc..

..alas it didn't work..

all advice/comments very much appreciated

Steven.

Post a sample of the csv datafile and the desired output.

Regards

thanks for the quick reply..

the csv's first two lines look like:

..and the desired output is valid entry into our ORACLE database via sqlldr.. (apologies if thats not what you meant..)

thanks again..

Steven

Try this:

Regards

..an error is being returned when I try to run this either by itself or in a script - am I not running it right?

$ cat SLsTester_DataFile.csv | awk BEGIN{FS=OFS=","}{for(i=1;i<=NF;i++){if($i=="0"){$i=""}}}1' file;

..the error given reads:

-bash: syntax error near unexpected token `('

your assistance is very much appreciated..

regards, Steven

Don't pipe the result of the cat command to the file. This is sufficient:

You can redirect the output to a file as follow:

Regards

..its stilll not running Im afraid..

$ awk 'BEGIN{FS=OFS=","}{for(i=1;i<=NF;i++){if($i=="0"){$i=""}}}1' SLsTester_DataFile.csv > SLsOUtputFile.csv;
awk: syntax error near line 1
awk: bailing out near line 1
/applmgr@fintest:~/finliveappl/su/11.5.0/payroll/gl $

..I've also tried running it within a script but it errors the same...

Thing is, as I have several date fields in each line ($5 $8 $9 $19 $20 $27) that may or may not need changing (exactly the same however, from zero to null), will this script simply swap ALL fields it finds with a zero only populated or will I need to specify field numbers?

Apologies for the questions but this is good for me to learn..

ThanksInAdvance...

Steven