<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: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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Ken,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Process runs, file created, Excel started with file loaded.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>I don’t want to add an extra step. It most likely
would be easier, if the “ doesn’t work to have them manually change
the column edit to text.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Thanks <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>Richard<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com
[mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com] <b>On
Behalf Of </b>Ken Cole<br>
<b>Sent:</b> Sunday, March 01, 2009 6:29 PM<br>
<b>To:</b> Fairlight<br>
<b>Cc:</b> filepro-list@lists.celestial.com<br>
<b>Subject:</b> Re: csv output<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>the single inverted comma is the Excel string marker -> '<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>However, I don't think excel recognises it in a csv file as
anuthing else than a valid character.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Somethimes it is better to define the file name with .dat
and Excel will not try to auto import it but starts an import wizard in which
yo can set column data types so you could then set the type for this
column to text and the problem would not occur.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Ken<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>On Sat, Feb 28, 2009 at 4:01 AM, Fairlight <<a
href="mailto:fairlite@fairlite.com">fairlite@fairlite.com</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>With neither thought nor caution, Richard Kreiss blurted:<o:p></o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>> Have a small problem and I
am sure one of you can answer this.<br>
><br>
> I am outputting a value 6 and a letter. If the value is either an A
or P,<br>
> when excel reads in the value, it converts to a time.<br>
><br>
> Any idea how to avoid this?<o:p></o:p></p>
</div>
<p class=MsoNormal>If memory serves, preceed your value with a single
doublequote to have it<br>
taken as a string literal.<br>
<br>
I'm assuming you mean it's being converted in Excel. If not, ignore the<br>
above.<br>
<br>
mark-><br>
<span style='color:#888888'>--<br>
"I'm not subtle. I'm not pretty, and I'll piss off a lot of people along<br>
the way. But I'll get the job done" --Captain Matthew Gideon,
"Crusade"</span><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal>_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>