<html><head></head><body>What about the XML file? I've never seen any options for creating one of those <br><br><div class="gmail_quote">On Apr 16, 2014, Walter D Vaughan Jr <wvaughan@steelerubber.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k10mail">Then you have at least two more options. <br />1) Export from filePro as a fixed format file and import as same in to Excel<br />2) Install SQL Server Express and setup a SSIS package to read your filePro<br />data as flat files and allow Excel to access the data somewhat natively (ala<br />ODBC or ADO) and of course this is a lot of work<br />3) Write your export to put the data into XML format which was developed in<br />part to eliminate this type of problem<br />4) translate your quote marks into the work inches before exporting<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">-----Original Message-----<br />From: filepro-list-bounces+wvaughan=<a href="http://steelerubber.com">steelerubber.com</a>@lists.celestial.com<br />[mailto:filepro-list-<br />bounces+wvaughan=<a href="http://steelerubber.com">steelerubber.com</a>@lists.celestial.com] On Behalf Of<br />FilePro List<br
/>Sent: Tuesday, April 15, 2014 5:07 PM<br />To: 0 Filepro List<br />Subject: Re: CSV Issues with quotes after a number<br /><br />getting rid of the quotes in all of my descriptions is not an option.<br />That would mess everything up.<br /><br />On 4/15/2014 3:38 PM, Chris Rendall wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;">I use the xlate command to remove the " from the data before export.<br /><br />--- Chris<br /><br />-----Original Message-----<br />From: FilePro List [mailto:mikefedkiwfp@aol.com]<br />Sent: Tuesday, April 15, 2014 2:28 PM<br />To: filepro-list@lists.celestial.com<br />Subject: CSV Issues with quotes after a number<br /><br />I am trying to export some information from my inventory file to a CSV<br /></blockquote></blockquote>file.<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">The info I need
to
export is item numbers, descriptions, prices, etc. I'm<br />having issues with the description field because some records contain a<br />quote after something like a length like 24". In those instances, it<br /></blockquote>sucks the<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">next field into the description field cell with a comma placed between<br /></blockquote>them.<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">This only happens if its a number followed by a quote, letters with quotes<br />after them work out just fine. I even tried changing the edit type on the<br />description fields to see if that made a difference but it didn't. I also<br /></blockquote>was just<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">thinking that I could move the
description field to the fart right and<br /></blockquote>there<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">wouldn't be anything to suck over but after doing that, it actually sucked<br /></blockquote>up<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">the next line under it.<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;">Any help would be greatly appreciated<br /><br />Thank You, Mike<br /><br /><br />Filepro 5.0.09DN9<br />MS Excel 2003<br />Server 2003<br /><hr /><br />Filepro-list mailing list<br />Filepro-list@lists.celestial.com<br />Subscribe/Unsubscribe/Subscription Changes<br /><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br /><hr /><br />Filepro-list
mailing list<br />Filepro-list@lists.celestial.com<br />Subscribe/Unsubscribe/Subscription Changes<br /><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></blockquote><br /><hr /><br />Filepro-list mailing list<br />Filepro-list@lists.celestial.com<br />Subscribe/Unsubscribe/Subscription Changes<br /><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a></blockquote><br /><hr /><br />Filepro-list mailing list<br />Filepro-list@lists.celestial.com<br />Subscribe/Unsubscribe/Subscription Changes<br /><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br /></pre></blockquote></div><br/>-- Sent with <b><a href="https://play.google.com/store/apps/details?id=com.onegravity.k10.pro2">K-@ Mail</a></b> - the evolution of emailing.</body></html>