Export to Excel

[Robert Haussmann]

Yikes--looks like the formatting got completely hosed on this message, sorry about that.  Hope you can track it.  Not sure if inline images are permitted on this list, but here's the two options I was talking bout:



[cid:image001.png at 01D43D6F.B8583640]



> -----Original Message-----

> From: Filepro-list [mailto:filepro-list-

> bounces+haussma=nextdimension.net at lists.celestial.com] On Behalf Of

> Robert Haussmann via Filepro-list

> Sent: Sunday, August 26, 2018 7:00 PM

> To: Scott Walker <scottwalker at ramsystemscorp.com>; 'Filepro List' <filepro-

> list at celestial.com>

> Subject: RE: Export to Excel

>

> It sort of depends on what you mean by "line by itself".  Which of the

> following are you trying to achieve?

>

>

> 12345

>

>

> Desc1 Text

> Desc 2 Text

> Desc 3 text

>

> 1234.33

>

>

>

>

>

> 12345

>

> Desc 1 Text

>

> 1234.33

>

> <--line 1

>

>

> Desc 2 Text

>

> <--line 2

>

>

> Desc 3 Text

>

> <--line 3

>

>

>

>

> (For the sake of clarity, the first option would use fields A1, B1 and C1 only;

> the second would use A1..C3).

>

>

>

> If you want the former (which I think you do), I *believe* (but from a rapidly

> fading memory), you do an ASCII export something like:

>

>

>

> Crlf=chr("13")&chr("10")

>

> exp(1)="12345";exp(2)="Desc 1 Text"{crlf{"Desc 2 Text"{crlf{"Desc 3

> Text";exp(3)="1234.44";write exp

>

>

>

> If the latter, you can just do a standard export where you do:

>

>

>

>                 exp(1)="12345";exp(2)="Desc 1 Text";exp(3)="12334.33";write exp

>

>                 exp(1)="";exp(2)="Desc 1 Text";exp(3)="";write exp

>

>                 exp(1)="";exp(2)="Desc 1 Text";exp(3)="";write exp

>

>

>

>

>

> Bob

>

>

>

> > -----Original Message-----

>

> > From: Filepro-list [mailto:filepro-list-

>

> > bounces+haussma=nextdimension.net at lists.celestial.com<mailto:bounces+haussma=nextdimension.net at lists.celestial.com>] On Behalf Of

>

> > Scott Walker via Filepro-list

>

> > Sent: Sunday, August 26, 2018 6:17 PM

>

> > To: 'Filepro List' <filepro-list at celestial.com<mailto:filepro-list at celestial.com>>

>

> > Subject: Export to Excel

>

> >

>

> > When I do an export to excel what do I need to insert in the data

> > stream to

>

> > get excel to do jump to a new line in the current cell.

>

> >

>

> > In my filepro file I have desc1 and desc2 and desc3 as separate fields.

>

> >

>

> > In Excel I want to end up with them all in one cell but each one on a

> > line by

>

> > itself like:

>

> >

>

> > Part# Description         List Price

>

> >

>

> > 12345                 Desc1 text           1234.33

>

> >             Desc2 text

>

> >             Desc3 text

>

> >

>

> >

>

> >

>

> > Regards,

>

> > Scott Walker

>

> >

>

> >

>

> >

>

> > _______________________________________________

>

> > Filepro-list mailing list

>

> > Filepro-list at lists.celestial.com<mailto:Filepro-list at lists.celestial.c<mailto:Filepro-list at lists.celestial.com%3cmailto:Filepro-list at lists.celestial.c>

> > om>

>

> > Subscribe/Unsubscribe/Subscription Changes

>

> > http://mailman.celestial.com/mailman/listinfo/filepro-list

> -------------- next part --------------

> An HTML attachment was scrubbed...

> URL: <http://mailman.celestial.com/pipermail/filepro-<http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attachment.html>

> list/attachments/20180826/8148c1ca/attachment.html<http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attachment.html>>

> _______________________________________________

> Filepro-list mailing list

> Filepro-list at lists.celestial.com<mailto:Filepro-list at lists.celestial.com>

> Subscribe/Unsubscribe/Subscription Changes

> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/80e2c544/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5458 bytes
Desc: image001.png
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/80e2c544/attachment.png>