Data Import

[Jay Ashworth]

----- Original Message -----
> From: "Brian K. White" <brian at aljex.com>
> To: "filePro Mailing List" <filepro-list at lists.celestial.com>
> Sent: Tuesday, March 12, 2013 4:48:50 PM
> Subject: Re: Data Import
> Bad advice.
> 
> --
> bkw
> 
> On 3/12/2013 8:43 AM, scooter6 at gmail.com wrote:
> >    Or you can run a simple sed script on the file first.....to
> >    remove the "
> >    sed -e 's/"//g'
> >
> >
> >
> > On Mon, Mar 11, 2013 at 10:45 AM, Kenneth Brody
> > <kenbrody at spamcop.net>wrote:
> >
> >> On 3/10/2013 10:05 PM, Scott Walker wrote:
> >>> Ken,
> >>>
> >>> Thanks for the input. It definitely handles the field surrounded
> >>> by the
> >> "
> >>> characters.
> >>
> >> FYI - The other option is to use the O= and C= flags. ("Import
> >> word" just
> >> sets the defaults to one of the common formats, CSV with quotes
> >> around
> >> [some] values.)
> >>
> >>> It definitely does not handle the field with the " in the actual
> >>> data.
> >>
> >> Can you give a specific example that "doesn't work"?
> >>
> >>> 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
> >>>
> >>>
> >>> _______________________________________________
> >>> Filepro-list mailing list
> >>> Filepro-list at lists.celestial.com
> >>> Subscribe/Unsubscribe/Subscription Changes
> >>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>>
> >>>
> >>
> >> --
> >> Kenneth Brody
> >> _______________________________________________
> >> Filepro-list mailing list
> >> Filepro-list at lists.celestial.com
> >> 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/20130312/8f9aab15/attachment.html
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

And this posting is nearly the *canonical* example of why top-posting 
and not clipping your quotes is antisocial behavior on technical mailing
lists.  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth                  Baylink                       jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com         2000 Land Rover DII
St Petersburg FL USA               #natog                      +1 727 647 1274