<div> Or you can run a simple sed script on the file first.....to remove the "</div><div> sed -e 's/"//g' </div><div><br><br> </div><div class="gmail_quote">On Mon, Mar 11, 2013 at 10:45 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div class="im">On 3/10/2013 10:05 PM, Scott Walker wrote:<br>
> Ken,<br>
><br>
> Thanks for the input. It definitely handles the field surrounded by the "<br>
> characters.<br>
<br>
</div>FYI - The other option is to use the O= and C= flags. ("Import word" just<br>
sets the defaults to one of the common formats, CSV with quotes around<br>
[some] values.)<br>
<div class="im"><br>
> It definitely does not handle the field with the " in the actual data.<br>
<br>
</div>Can you give a specific example that "doesn't work"?<br>
<div class="HOEnZb"><div class="h5"><br>
> This is what I always seem to find with import. One way handles some issues<br>
> but not others. Change it...you fix some problems, make others.<br>
><br>
> I don't see this as a problem with fp import command. I think the data I<br>
> get is FUBAR.<br>
><br>
> Thanks again for taking the time.<br>
><br>
> Regards,<br>
><br>
> Scott<br>
><br>
>> -----Original Message-----<br>
>> From: filepro-list-<br>
>> bounces+scottwalker=<a href="mailto:ramsystemscorp.com@lists.celestial.com">ramsystemscorp.com@lists.celestial.com</a><br>
>> [mailto:<a href="mailto:filepro-list-">filepro-list-</a><br>
>> bounces+scottwalker=<a href="mailto:ramsystemscorp.com@lists.celestial.com">ramsystemscorp.com@lists.celestial.com</a>] On Behalf Of<br>
>> Ken Cole<br>
>> Sent: Sunday, March 10, 2013 9:09 PM<br>
>> To: Scott Walker<br>
>> Cc: filePro Mailing List<br>
>> Subject: Re: Data Import<br>
>><br>
>> "Import word" does it automatically.<br>
>><br>
>> Ken<br>
>><br>
>> On Monday, 11 March 2013, Scott Walker wrote:<br>
>><br>
>>> I am importing from an .csv file.<br>
>>><br>
>>> Data is separated by commas.<br>
>>><br>
>>> If a field contains a comma in it the field is enclosed in "<br>
>>><br>
>>> Example:<br>
>>><br>
>>> Scott, Walker,"112 Main Street, Suite 12",Charlotte,NC,28212<br>
>>><br>
>>><br>
>>> What's the best way to import into fp so I get the 112 Main Street,<br>
>>> Suite<br>
>>> 12<br>
>>> in the field without the ".<br>
>>><br>
>>> Sorry for this basic question, but imports always seem to befuddle me.<br>
>>><br>
>>> Regards,<br>
>>> Scott<br>
>>><br>
>>><br>
>>> Scott Walker<br>
>>> RAM Systems Corp<br>
>>> (704) 896-6549<br>
>>> Scott.Walker@RAMSystemsCorp.com<br>
>>><br>
>>> <a href="http://www.RAMSystemsCorp.com" target="_blank">www.RAMSystemsCorp.com</a><br>
>>><br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> Filepro-list mailing list<br>
>>> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a> <javascript:;><br>
>>> Subscribe/Unsubscribe/Subscription Changes<br>
>>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
>>><br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <a href="http://mailman.celestial.com/pipermail/filepro-" target="_blank">http://mailman.celestial.com/pipermail/filepro-</a><br>
>> list/attachments/20130311/021ace82/attachment.html<br>
>> _______________________________________________<br>
>> Filepro-list mailing list<br>
>> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
>> Subscribe/Unsubscribe/Subscription Changes<br>
>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
><br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Kenneth Brody<br>
</font></span><div class="HOEnZb"><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br>