<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=gb2312">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.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>My boss is having fits with an extract that should contain
special characters for names like José, etc. It contains special
characters, but not what he’s expecting. From my perspective, everything’s
fine. <span style='font-family:Wingdings'>J</span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>The only thing different with this DOWNLOAD from my usual
ones is I use the pipe symbol for the delimiter and use no quotation marks.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>After DOWNLOADing, I go to the AIX prompt and cat the file
and the records appear fine. In this case, José has the nice
accented e (é).<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I ftp the data to my Win XP machine and open the file in
Notepad, WordPad, or Crimson Editor, (even pulled it up fine in Excel) it continues
to display properly as José. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>At a DOS prompt, though, when I do “type” it shows me JosΘ.
(An “O” with a dash in the middle in case it doesn’t display properly in this
e-mail.). <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>So, all my text editors recognize the ASCII and display it
properly and the command line doesn’t. Apparently he’s getting the “O”
with a dash in the middle and the webapp he’s using the data file with is
having issues importing the information.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When I provided him the data during testing, I would send it
to him via uuencode and the mail command. Now it is set up in cron to
drop the file into a common ftp spot. It seems uuencode fixed the
characters properly, but I don’t want to send it as an attachment.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I’ve played with iconv and dd without luck thus far, but I’m
just familiar enough with them to be dangerous. Is there a setting in
DOWNLOAD to ensure an ASCII format that “plays nice” on a Win-XP platform?
Or do I need to do something else (like the uuencode, dd, or iconv commands)?
<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Suggestions welcome, thanks!<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Jeff Summers<o:p></o:p></p>
<p class=MsoNormal>Administrative Computing<o:p></o:p></p>
<p class=MsoNormal>Transylvania University<o:p></o:p></p>
<p class=MsoNormal>300 N. Broadway<o:p></o:p></p>
<p class=MsoNormal>Lexington, KY 40508<o:p></o:p></p>
<p class=MsoNormal><a href="mailto:jsummers@transy.edu">jsummers@transy.edu</a><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<DIV><P><HR>
Successfully Scanned by the McAfee SIG 3200 Appliance.
</P></DIV>
</body>
</html>