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 5:33 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 4:53 PM, Scott Walker wrote:
> >> I have a file with part#, description line 1, description line 2 and
> >> description line 3
> >>
> >> I want to export these fields to a csv file and then import it into
> >> excel
> >>
> >> I want part# to be in column a and the three lines of description to
> >> all be in column b.
> >>
> >>
> >> Sort of like:
> >>
> >>
> >> Part#		Description
> >>
> >> 123434		Description Line One Text
> >> 		Description Line Two Text
> >> 		Description Line Three Text
> >>
> >> 3322222	Description Line One Text
> >> 		Description Line Two Text
> >>
> >> Is this possible.
> >>
> > To be more precise,  I want all the description lines to be in one
> > Excel cell.
> 
> 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.
> 
> --
> Kenneth Brody

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.

Regards,

Scott