Re: Removing quotes from tab delimited file

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

> I am creating a tab delimited file from our iSeries using Sequel.  This
> file is imported by another application.  When Sequel creates the file,
> a date field is surrounded by quotes ie "11/01/2005".  Does anyone know
> of a way to remove the quotes from the file.  It wont import into my
> application.

If you want to remove all quotes from the data (no matter where they are 
in the file) you can run the following QShell command:

     tr -d '\177' < /path/to/input.csv > /path/to/output.csv

The TR utility will delete any character with octal EBCDIC value 177 
(which is hex x'7F', and is the quote character.)

If you have QShell installed, you can run this from a CL program with:

     STRQSH CMD(tr -d ''\177'' < /path/to/input.csv +
                               > /path/to/output.csv

Otherwise... you could write a program that does it.