Data Import

[scooter6 at gmail.com]

  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