Data Import

[Kenneth Brody]

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