<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)">
<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;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-compose;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
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">It sort of depends on what you mean by "line by itself". Which of the following are you trying to achieve?<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="356" style="width:267.0pt;border-collapse:collapse">
<tbody>
<tr style="height:45.0pt">
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">12345<o:p></o:p></span></p>
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black"><o:p> </o:p></span></p>
</td>
<td width="164" valign="bottom" style="width:123.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.0pt">
<p class="MsoNormal"><span style="color:black">Desc1 Text<br>
Desc 2 Text<br>
Desc 3 text<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">1234.33<o:p></o:p></span></p>
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black"><o:p> </o:p></span></p>
</td>
<td style="border:none;padding:0in 0in 0in 0in" width="64">
<p class="MsoNormal"> </p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">12345<o:p></o:p></span></p>
</td>
<td width="164" nowrap="" valign="bottom" style="width:123.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black">Desc 1 Text<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">1234.33<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black"><--line 1<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="164" nowrap="" valign="bottom" style="width:123.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black">Desc 2 Text<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black"><--line 2<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="164" nowrap="" valign="bottom" style="width:123.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black">Desc 3 Text<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="64" nowrap="" valign="bottom" style="width:48.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black"><--line 3<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">(For the sake of clarity, the first option would use fields A1, B1 and C1 only; the second would use A1..C3).<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">If you want the former (which I think you do), I *<b>believe</b>* (but from a rapidly fading memory), you do an ASCII export something like:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Crlf=chr(“13”)&chr(“10”)<o:p></o:p></p>
<p class="MsoPlainText">exp(1)=”12345”;exp(2)=”Desc 1 Text”{crlf{“Desc 2 Text”{crlf{“Desc 3 Text”;exp(3)=”1234.44”;write exp<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">If the latter, you can just do a standard export where you do:<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"> exp(1)=”12345”;exp(2)=”Desc 1 Text”;exp(3)=”12334.33”;write exp<o:p></o:p></p>
<p class="MsoPlainText"> exp(1)=””;exp(2)=”Desc 1 Text”;exp(3)=””;write exp<o:p></o:p></p>
<p class="MsoPlainText"> exp(1)=””;exp(2)=”Desc 1 Text”;exp(3)=””;write exp<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Bob<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">> -----Original Message-----<o:p></o:p></p>
<p class="MsoPlainText">> From: Filepro-list [mailto:filepro-list-<o:p></o:p></p>
<p class="MsoPlainText">> bounces+haussma=nextdimension.net@lists.celestial.com] On Behalf Of<o:p></o:p></p>
<p class="MsoPlainText">> Scott Walker via Filepro-list<o:p></o:p></p>
<p class="MsoPlainText">> Sent: Sunday, August 26, 2018 6:17 PM<o:p></o:p></p>
<p class="MsoPlainText">> To: 'Filepro List' <filepro-list@celestial.com><o:p></o:p></p>
<p class="MsoPlainText">> Subject: Export to Excel<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> When I do an export to excel what do I need to insert in the data stream to<o:p></o:p></p>
<p class="MsoPlainText">> get excel to do jump to a new line in the current cell.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> In my filepro file I have desc1 and desc2 and desc3 as separate fields.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> In Excel I want to end up with them all in one cell but each one on a line by<o:p></o:p></p>
<p class="MsoPlainText">> itself like:<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Part# Description List Price<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> 12345 Desc1 text 1234.33<o:p></o:p></p>
<p class="MsoPlainText">> Desc2 text<o:p></o:p></p>
<p class="MsoPlainText">> Desc3 text<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Regards,<o:p></o:p></p>
<p class="MsoPlainText">> Scott Walker<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> _______________________________________________<o:p></o:p></p>
<p class="MsoPlainText">> Filepro-list mailing list<o:p></o:p></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><o:p></o:p></p>
<p class="MsoPlainText">> Subscribe/Unsubscribe/Subscription Changes<o:p></o:p></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><o:p></o:p></p>
</div>
</body>
</html>