Export Multiple Fields of Data to One Excel Cell

[Richard Kreiss]

Scott 

Why not concatenate the descriptions into one dummy field and export that?

Richard
Sent from my iPhone

On Apr 26, 2012, at 7:48 PM, "Scott Walker" <ScottWalker at RAMSystemsCorp.com> wrote:

> 
> 
>> -----Original Message-----
>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>> Sent: Thursday, April 26, 2012 7:02 PM
>> To: Scott Walker
>> Cc: filepro-list at lists.celestial.com
>> Subject: Re: Export Multiple Fields of Data to One Excel Cell
>> 
>> On 4/26/2012 6:36 PM, Scott Walker wrote:
>>>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>> [...]
>>>> A quick test with Excel 2007 shows that you can put a multi-line
>>>> string inside of quotes, and it imports it as a single cell from a CSV
>> file.
>>>> 
>>>> You should be able to simply put all of the description lines into a
>>>> single filePro field -- use CHR("10") to insert a line-break -- and
>>>> export it as usual.
>>> 
>>> Ken,
>>> 
>>> Thanks for taking a shot but that just does not work for me.  I found
>>> that from the keyboard, Excel uses<Alt><Enter>  as it's soft return.
>>> Maybe someone could tell me the codes for that I can try inserting
>>> them into the file.
>> 
>> "DDW".
>> 
>> Try the attached CSV file.
>> 
>> --
>> Kenneth Brody
> 
> Ken,
> 
> Very interesting.  When I open it the "extra" lines of description do not
> show.  But if I go into one of the description cells and start editing it,
> all for lines of description are displayed.  Excel is weird!  Can you show
> me the fp code you used to generate this csv file.
> 
> Regards,
> 
> Scott
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list