Export to Excel
Scott Walker
scottwalker at ramsystemscorp.com
Sun Aug 26 16:29:13 PDT 2018
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
More information about the Filepro-list
mailing list