Export to Excel

Sun Aug 26 17:00:32 PDT 2018

In excel itself, you are right it is the alt+enter.  I think you can replicate that in fP by doing "field" { chr("13") { chr("10") { "Field 2" etc.

Bob

> -----Original Message-----
> From: Scott Walker [mailto:scottwalker at ramsystemscorp.com]
> Sent: Sunday, August 26, 2018 7:29 PM
> To: Robert Haussmann <haussma at nextdimension.net>
> Cc: 'Filepro List' <filepro-list at celestial.com>
> Subject: RE: Export to Excel
> 
> Bob,
> 
> What am trying to accomplish is what you are showing as the first example on
> your spreadsheet.
> 
> What keystrokes are you pressing between "Desc1 Text" and "Desc2 Text"?
> 
> Regards,
> Scott
> 
> 
> -----Original Message-----
> From: Robert Haussmann [mailto:haussma at nextdimension.net]
> Sent: Sunday, August 26, 2018 7:07 PM
> To: Scott Walker <scottwalker at ramsystemscorp.com>
> Subject: RE: Export to Excel
> 
> I can't win with this email list.  Attaching a JPG the old school way..
> Sorry for the confusion.
> 
> Bob
> 
> > -----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:05 PM
> > To: Scott Walker <scottwalker at ramsystemscorp.com>; 'Filepro List'
> > <filepro- list at celestial.com>
> > Subject: RE: Export to Excel
> >
> > 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
> > > > bounces++haussma=nextdimension.net at lists.celestial.com>] On
> Behalf
> > > > bounces+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.celesti
> > > > al
> > > > .c<mailto:Filepro-list at lists.celestial.com%3cmailto:Filepro-list at l
> > > > is
> > > > ts.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.cele
> > > st
> > > ial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attachm
> > > en
> > > t.html>
> >
> > >
> >
> list/attachments/20180826/8148c1ca/attachment.html<http://mailman.cele
> > > stial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attac
> > > hm
> > > ent.html>>
> >
> > > _______________________________________________
> >
> > > Filepro-list mailing list
> >
> > > Filepro-list at lists.celestial.com<mailto: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-
> > 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>
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list