Export Multiple Fields of Data to One Excel Cell

[Scott Walker]

Ken,

I did as you suggested but when I import the data into excel I'm still
getting the descriptions in the wrong column.

Thanks for the help.  I'm going to try this a different way tomorrow.

Regards,

Scott



> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> Kenneth Brody
> Sent: Thursday, April 26, 2012 8:51 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 8:34 PM, Scott Walker wrote:
> > Richard,
> >
> > Because I want them to appear as separate lines in the SAME cell.
> 
> Do as I said in my first reply, concatenate them together into a single
> field, using CHR("10") to break them into separate lines.
> 
> >
> > Regards,
> >
> > Scott
> >
> >> -----Original Message-----
> [...]
> >> On Behalf Of Richard Kreiss
> [...]
> >>
> >> Scott
> >>
> >> Why not concatenate the descriptions into one dummy field and export
> that?
> >>
> >> Richard
> [...]
> >>>> From: Kenneth Brody [mailto:kenbrody at spamcop.net] 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.
> >>>
> >>> 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.
> 
> --
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list