CSV Issues with quotes after a number

[Mike Fedkiw]

What about the XML file? I've never seen any options for creating one of those 

On Apr 16, 2014, Walter D Vaughan Jr <wvaughan at steelerubber.com> wrote:
>Then you have at least two more options. 
>1) Export from filePro as a fixed format file and import as same in to
>Excel
>2) Install SQL Server Express and setup a SSIS package to read your
>filePro
>data as flat files and allow Excel to access the data somewhat natively
>(ala
>ODBC or ADO) and of course this is a lot of work
>3) Write your export to put the data into XML format which was
>developed in
>part to eliminate this type of problem
>4) translate your quote marks into the work inches before exporting
>
>> -----Original Message-----
>> From:
>filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
>> [mailto:filepro-list-
>> bounces+wvaughan=steelerubber.com at lists.celestial.com] On Behalf Of
>> FilePro List
>> Sent: Tuesday, April 15, 2014 5:07 PM
>> To: 0 Filepro List
>> Subject: Re: CSV Issues with quotes after a number
>> 
>> getting rid of the quotes in all of my descriptions is not an option.
>> That would mess everything up.
>> 
>> On 4/15/2014 3:38 PM, Chris Rendall wrote:
>> > I use the xlate command to remove the " from the data before
>export.
>> >
>> > --- Chris
>> >
>> > -----Original Message-----
>> > From: FilePro List [mailto:mikefedkiwfp at aol.com]
>> > Sent: Tuesday, April 15, 2014 2:28 PM
>> > To: filepro-list at lists.celestial.com
>> > Subject: CSV Issues with quotes after a number
>> >
>> > I am trying to export some information from my inventory file to a
>CSV
>file.
>> The info I need to export is item numbers, descriptions, prices, etc.
>I'm
>> having issues with the description field because some records contain
>a
>> quote after something like a length like 24".  In those instances, it
>sucks the
>> next field into the description field cell with a comma placed
>between
>them.
>> This only happens if its a number followed by a quote, letters with
>quotes
>> after them work out just fine. I even tried changing the edit type on
>the
>> description fields to see if that made a difference but it didn't. I
>also
>was just
>> thinking that I could move the description field to the fart right
>and
>there
>> wouldn't be anything to suck over but after doing that, it actually
>sucked
>up
>> the next line under it.
>> >
>> > Any help would be greatly appreciated
>> >
>> > Thank You, Mike
>> >
>> >
>> > Filepro 5.0.09DN9
>> > MS Excel 2003
>> > Server 2003
>> > _______________________________________________
>> > 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
>> 
>> _______________________________________________
>> 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

-- Sent with K-@ Mail - the evolution of emailing.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140416/6cd738c1/attachment.html