Export to Excel

[Robert Haussmann]

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] On Behalf Of

> Scott Walker via Filepro-list

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

> To: 'Filepro List' <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.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/8148c1ca/attachment.html>