Data Import

[Brian K. White]

Guilty. :)

-- 
bkw

On 3/12/2013 5:52 PM, Jay Ashworth wrote:
> ----- 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
>