<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 14 (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: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: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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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=blue vlink=purple><div class=WordSection1><p class=MsoNormal> I have been working on a pretty simple .CSV spreadsheet import example for my filePro class tonight and I’m not able to figure out what is wrong with it. The students are running filePro version 5.6.11R4 on a Linux server (2.6.32-573.18.1.el6.x86_64 #1).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> When I try to save the code (1st screen), I get a syntax check on line 26 (2<sup>nd</sup> screen). <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> I do *<b>not</b>* get a syntax error if I try to examine the first 11 fields of the jobcsv file. IE; “jobcsv(11)=”Totals:” passes the syntax check but “jobcsv(12)=”Totals:” does not pass the syntax check.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> If it makes any difference, the actual test spreadsheet they wanted me to show them how to import is about 100 columns wide with a header row that we want to skip past. It also has a row of “Totals:” on the bottom of the sheet that we also do not want to import. I should be able to skip past (not import) the totals line at the bottom by examining the 12<sup>th</sup> column of the spreadsheet to see if the “Totals:” is in column 12. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Mike<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><img width=884 height=509 id="Picture_x0020_1" src="cid:image001.png@01D53BE3.6021A3D0"><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><img width=884 height=509 id="Picture_x0020_2" src="cid:image002.png@01D53BE3.C54EABE0"><o:p></o:p></p></div></body></html>