<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 129.75pt 1.0in 129.7pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoPlainText">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:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><img width="386" height="241" id="Picture_x0020_1" src="cid:image001.png@01D43D6F.B8583640"><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">> -----Original Message-----</p>
<p class="MsoPlainText">> From: Filepro-list [mailto:filepro-list-</p>
<p class="MsoPlainText">> bounces+haussma=nextdimension.net@lists.celestial.com] On Behalf Of</p>
<p class="MsoPlainText">> Robert Haussmann via Filepro-list</p>
<p class="MsoPlainText">> Sent: Sunday, August 26, 2018 7:00 PM</p>
<p class="MsoPlainText">> To: Scott Walker <scottwalker@ramsystemscorp.com>; 'Filepro List' <filepro-</p>
<p class="MsoPlainText">> list@celestial.com></p>
<p class="MsoPlainText">> Subject: RE: Export to Excel</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> It sort of depends on what you mean by "line by itself". Which of the</p>
<p class="MsoPlainText">> following are you trying to achieve?</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> 12345</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Desc1 Text</p>
<p class="MsoPlainText">> Desc 2 Text</p>
<p class="MsoPlainText">> Desc 3 text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> 1234.33</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> 12345</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Desc 1 Text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> 1234.33</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> <--line 1</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Desc 2 Text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> <--line 2</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Desc 3 Text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> <--line 3</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> (For the sake of clarity, the first option would use fields A1, B1 and C1 only;</p>
<p class="MsoPlainText">> the second would use A1..C3).</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> If you want the former (which I think you do), I *believe* (but from a rapidly</p>
<p class="MsoPlainText">> fading memory), you do an ASCII export something like:</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Crlf=chr("13")&chr("10")</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> exp(1)="12345";exp(2)="Desc 1 Text"{crlf{"Desc 2 Text"{crlf{"Desc 3</p>
<p class="MsoPlainText">> Text";exp(3)="1234.44";write exp</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> If the latter, you can just do a standard export where you do:</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> exp(1)="12345";exp(2)="Desc 1 Text";exp(3)="12334.33";write exp</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> exp(1)="";exp(2)="Desc 1 Text";exp(3)="";write exp</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> exp(1)="";exp(2)="Desc 1 Text";exp(3)="";write exp</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> Bob</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > -----Original Message-----</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > From: Filepro-list [mailto:filepro-list-</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > <a href="mailto:bounces+haussma=nextdimension.net@lists.celestial.com">
<span style="color:windowtext;text-decoration:none">bounces+haussma=nextdimension.net@lists.celestial.com</span></a>] On Behalf Of</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Scott Walker via Filepro-list</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Sent: Sunday, August 26, 2018 6:17 PM</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > To: 'Filepro List' <<a href="mailto:filepro-list@celestial.com"><span style="color:windowtext;text-decoration:none">filepro-list@celestial.com</span></a>></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Subject: Export to Excel</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > When I do an export to excel what do I need to insert in the data</p>
<p class="MsoPlainText">> > stream to</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > get excel to do jump to a new line in the current cell.</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > In my filepro file I have desc1 and desc2 and desc3 as separate fields.</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > In Excel I want to end up with them all in one cell but each one on a</p>
<p class="MsoPlainText">> > line by</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > itself like:</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Part# Description List Price</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > 12345 Desc1 text 1234.33</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Desc2 text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Desc3 text</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Regards,</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Scott Walker</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> ></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > _______________________________________________</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Filepro-list mailing list</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > <a href="mailto:Filepro-list@lists.celestial.com%3cmailto:Filepro-list@lists.celestial.c">
<span style="color:windowtext;text-decoration:none">Filepro-list@lists.celestial.com<mailto:Filepro-list@lists.celestial.c</span></a></p>
<p class="MsoPlainText">> > om></p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > Subscribe/Unsubscribe/Subscription Changes</p>
<p class="MsoPlainText">> </p>
<p class="MsoPlainText">> > <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">
<span style="color:windowtext;text-decoration:none">http://mailman.celestial.com/mailman/listinfo/filepro-list</span></a></p>
<p class="MsoPlainText">> -------------- next part --------------</p>
<p class="MsoPlainText">> An HTML attachment was scrubbed...</p>
<p class="MsoPlainText">> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attachment.html"><span style="color:windowtext;text-decoration:none">http://mailman.celestial.com/pipermail/filepro-</span></a></p>
<p class="MsoPlainText"><a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20180826/8148c1ca/attachment.html"><span style="color:windowtext;text-decoration:none">> list/attachments/20180826/8148c1ca/attachment.html</span></a>></p>
<p class="MsoPlainText">> _______________________________________________</p>
<p class="MsoPlainText">> Filepro-list mailing list</p>
<p class="MsoPlainText">> <a href="mailto:Filepro-list@lists.celestial.com"><span style="color:windowtext;text-decoration:none">Filepro-list@lists.celestial.com</span></a></p>
<p class="MsoPlainText">> Subscribe/Unsubscribe/Subscription Changes</p>
<p class="MsoPlainText">> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">
<span style="color:windowtext;text-decoration:none">http://mailman.celestial.com/mailman/listinfo/filepro-list</span></a></p>
</div>
</body>
</html>