plz...can anyone modify this script

markjason · #1 (**permalink**) 08-29-04, 12:13

HTML Code:

file=$1
var1=`nawk -F~ '{ for( i = 1; i<= NF; ++i )
if ( $i != "" ) { print "'"'"'"$i"'"'"'""," }
else {print"NULL,"}}' $file`

var2=`echo $var1 | sed -e 's/, /,/g;s/,$//g'| sed 
's/'\'SYSDATE\''/SYSDATE/g'`

#echo $var2

var3= `nawk -F, '{ for( i = 1; i<= NF; i++ )
if ( i == 5 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
elseif ( i == 8 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
elseif ( i == 23 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
elseif ( i == 38 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
elseif ( i == 40 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
elseif ( i == 42 ) { echo $i | sed 's/'\'"$i"\''/"$i"/g' }
else { print "$i" } }'$var2`

echo $var3

my input
:~~~~6852~TA~APM_0003~35~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~TEST
APM_0003->GFSTM_EMAIL_PROCESS_EXCEPT_PR~~~~~~~~APMDV_SRC~TO _DATE(2-06-2004 08:16:18,DD-MM-YYYY HH24:MI

S)~APMDV_SRC~TO_DATE(2-06-2004
08:16:18,DD-MM-YYYY HH24:MI

S)~TO_DATE(2-06-2004 08:16:18,DD-MM-YYYY
HH24:MI

S)~Oracle Error~

desired
output
:NULL,NULL,NULL,NULL,'6852','TA','APM_0003','35',N ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,NULL,'TEST
APM_0003->GFSTM_EMAIL_PROCESS_EXCEPT_PR',NULL,NULL,NULL,NUL L,NULL,NULL,NULL,'APMDV_SRC','TO_DATE(2-06-2004
08:16:18,DD-MM-YYYY HH24:MI

S)','APMDV_SRC','TO_DATE(2-06-2004
08:16:18,DD-MM-YYYY HH24:MI

S)','TO_DATE(2-06-2004 08:16:18,DD-MM-YYYY
HH24:MI

S)','Oracle Error',NULL

TO_DATE(2-06-2004 08:16:18,DD-MM-YYYY HH24:MI

S) should not be in
quotes like sysdate.

if sysdate and to_date are coming with quotes then i should remove quotes and if they are not coming with quotes then leave as it is... i am trying out above code its not working... is there any other effiecient way to do the above requirment.

Thanks
Markjason.

vgersh99 · #2 (**permalink**) 08-30-04, 10:54

how 'bout this awk snippet:

Code:

BEGIN {
  FS="~"
  OFS=","
}

function doField(str)
{
  sub("^[ ]*", "", str);
  sub("[ ]*$", "", str);

  str = (match(str, /[A-Za-z0-9]/)) ? "'" str "'" : str "NULL";

  return str
}

{
  for(i=1; i <= NF; i++)
    printf("%s%s", doField($i), (i==NF) ? "\n" : OFS);
}