RE: Removing quotes from tab delimited file

["D.W." <dpalme@xxxxxxxxxxx>]

This is going to be an off the wall question for Scott, but how in the
world do you know all of this? I am not questioning your expertise,
quite the contrary....everytime I see a post from you and a select group
of others, I sit up and take notice.....most of the time like this I
copy it and put it in a notebook for future reference.

Just curious how you have been able to acquire all the knowledge you
have?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, November 09, 2005 3:29 PM
To: Midrange Systems Technical Discussion
Subject: Re: Removing quotes from tab delimited file



> 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.