Re: prob: to convert data from an excel sheet onto the as400 environment.

For a one off situation, the process I use is like this:

2. Delete header rows and any blank rows at the end of the file

CPYFRMIMPF FROMSTMF('/home/<me>/<myfile>')

          RPLNULLVAL(*FLDDFT)

Here's the awk script:
BEGIN {
   # Tab delimited file
   FS="\t";
   OFS="\t";
}
/./ {
   # For each field in the current record
   for (i=1;i<=NF;i++) {
       # Remove the first and last character from the field
       # only if both are quotes.
       if (($i ~ /^\"/) && ($i ~ /\"$/)) {
           # Remove the beginning quote
           gsub("^\"","",$i);
           # Remove the ending quote
           gsub("\"$","",$i);
       }
       # Replace multiple contiguous quotes with a single quote
       gsub("\"+","\"",$i);
   }
   print;
}