Export Multiple Fields of Data to One Excel Cell

[Scott Walker]

> -----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