import

[Richard Kreiss]

> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of GCC Consulting
> Sent: Friday, January 18, 2013 1:29 PM
> To: 'Kenneth Brody'
> Cc: filepro-list at lists.celestial.com
> Subject: RE: import
> 
> 
> 
> > -----Original Message-----
> > From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> > Sent: Friday, January 18, 2013 12:41 PM
> > To: GCC Consulting
> > Cc: filepro-list at lists.celestial.com
> > Subject: Re: import
> >
> > On 1/18/2013 12:26 PM, GCC Consulting wrote:
> > > Windows:
> > >
> > > I am importing a csv file where one field is a long description.  In
> > > some cases some word are surrounded by single quotes 'work order'.
> > > These are being translated to graphics characters.  Is there any way
> > > to have these imported as single quotes rather than graphics
characters?
> > >
> > > My csv file contains the single quotes.
> >
> > It sounds to me like they are *not* single-quotes, as in 'work order',
> > but
> the
> > typographer quotes, as in 'work order'.
> >
> > --
> > Kenneth Brody
> 
> 
> Probably as I converted the tables in a pdf to an excel file and then
exported
> them to a csv.
> 
> I know what the graphic characters look like.  If I can find their
character code,
> I should then be able to delete them and replace them with a single quote.
> 
> Richard

Found the ASCII codes for the characters 145 & 146.  Used xlate to replace
with a single quotes.

Richard