Export to Excel

Robert Haussmann haussma at nextdimension.net
Sun Aug 26 17:44:26 PDT 2018 

I thought alt+enter was just emulating a CR/LF to be honest.

Bob

> -----Original Message-----
> From: Scott Walker [mailto:scottwalker at ramsystemscorp.com]
> Sent: Sunday, August 26, 2018 8:24 PM
> To: Robert Haussmann <haussma at nextdimension.net>
> Cc: 'Filepro List' <filepro-list at celestial.com>
> Subject: RE: Export to Excel
> 
> doing the cr /nl thing with chr just puts the next line of description in the first
> cell of the next row <ctrl><enter> does not work when I actually try it in the
> spreadsheet <Alt><Enter> does work when I actually try it in the
> spreadsheet
> 
> So the question is how do I get <Alt><Enter> in the datastream?
> 
> Regards,
> Scott
> 
> 
> -----Original Message-----
> From: Robert Haussmann [mailto:haussma at nextdimension.net]
> Sent: Sunday, August 26, 2018 8:01 PM
> To: Scott Walker <scottwalker at ramsystemscorp.com>
> Cc: 'Filepro List' <filepro-list at celestial.com>
> Subject: RE: Export to Excel
> 
> 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
> > > > bounces+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.celes
> > > > > ti
> > > > > al
> > > > > .c<mailto:Filepro-list at lists.celestial.com%3cmailto:Filepro-list
> > > > > @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.ce
> > > > le
> > > > st
> > > > ial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attac
> > > > hm
> > > > en
> > > > t.html>
> > >
> > > >
> > >
> >
> list/attachments/20180826/8148c1ca/attachment.html<http://mailman.cele
> > > > stial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/att
> > > > ac
> > > > hm
> > > > ent.html>>
> > >
> > > > _______________________________________________
> > >
> > > > Filepro-list mailing list
> > >
> > > > Filepro-list at lists.celestial.com<mailto:Filepro-list at lists.celesti
> > > > al
> > > > .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

More information about the Filepro-list mailing list