Data Import

[Scott Walker]

Ken,

Thanks for the input.  It definitely handles the field surrounded by the "
characters.

It definitely does not handle the field with the " in the actual data.

This is what I always seem to find with import.  One way handles some issues
but not others.  Change it...you fix some problems, make others.

I don't see this as a problem with fp import command.  I think the data I
get is FUBAR.

Thanks again for taking the time.

Regards,

Scott

> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> Ken Cole
> Sent: Sunday, March 10, 2013 9:09 PM
> To: Scott Walker
> Cc: filePro Mailing List
> Subject: Re: Data Import
> 
> "Import word" does it automatically.
> 
> Ken
> 
> On Monday, 11 March 2013, Scott Walker wrote:
> 
> > I am importing from an .csv file.
> >
> > Data is separated by commas.
> >
> > If a field contains a comma in it the field is enclosed in "
> >
> > Example:
> >
> > Scott, Walker,"112 Main Street, Suite 12",Charlotte,NC,28212
> >
> >
> > What's the best way to import into fp so I get the 112 Main Street,
> > Suite
> > 12
> > in the field without the ".
> >
> > Sorry for this basic question, but imports always seem to befuddle me.
> >
> > Regards,
> > Scott
> >
> >
> > Scott Walker
> > RAM Systems Corp
> > (704) 896-6549
> > Scott.Walker at RAMSystemsCorp.com
> >
> > www.RAMSystemsCorp.com
> >
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com <javascript:;>
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20130311/021ace82/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list