<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">Filepro 5.7.00.0D94</div><div class="">FreeBSD </div><div class=""><br class=""></div><div class="">I am trying to write an import routine of csv files where the columns will not be consistent each time. instead, the header row will determine which column contains which value. this will become part of a daily routine import, but there will be no way for me to control the column assignments for each file. </div><div class=""><br class=""></div><div class="">is there any way to refer to the field number of the import with a variable instead of a static number? Thank you very much, </div><div class=""><br class=""></div><div class="">file 1: </div><div class="">first name,last name,…</div><div class="">Mike,Jones,…</div><div class=""><br class=""></div><div class="">file 2</div><div class="">phone number, city, last name,…</div><div class="">555-555-1212,Atlanta,Jones,...</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><font face="Monaco" class="">::declare local cnt(6,.0):</font></div><div class=""><font face="Monaco" class="">::':</font></div><div class=""><font face="Monaco" class="">::cnt="1":</font></div><div class=""><font face="Monaco" class="">::fn="/tmp/transfer/"{@pm:</font></div><div class=""><font face="Monaco" class="">loop::':</font></div><div class=""><font face="Monaco" class="">::import ascii inf=(fn) r=\n f=~:</font></div><div class=""><font face="Monaco" class="">:cnt eq "1":po="1";goto get_poc:</font></div><div class=""><font face="Monaco" class="">:not inf:delete;exit:</font></div><div class=""><font face="Monaco" class="">::lookup customer r=free -e:</font></div><div class=""><font face="Monaco" class="">::customer(1)=inf(po):</font></div><div class=""><font face="Monaco" class="">::close customer:</font></div><div class=""><font face="Monaco" class="">::cnt=cnt+”1"</font></div><div class=""><font face="Monaco" class="">::goto loop:</font></div><div class=""><font face="Monaco" class="">::':</font></div><div class=""><font face="Monaco" class="">get_poc::':</font></div><div class=""><font face="Monaco" class="">:inf(po) co “last name":goto loop:</font></div><div class=""><font face="Monaco" class="">::po=po+"1":</font></div><div class=""><font face="Monaco" class="">::goto get_poc:</font></div><div class=""><font face="Monaco" class="">::': </font></div><div class=""><br class=""></div><div class=""><div class="">inf(po) co “last name"</div><div class=""> ^</div><div class="">Process contains a syntax error at position indicated.</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><br class=""><div class="">
<div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><br class="Apple-interchange-newline"><br class=""></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">James Flanagan</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span class="" style="text-decoration: underline;"><a href="http://Flantec.com/" class="">Flantec.com</a></span></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br class=""></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span class="" style="color: rgb(121, 121, 121);">email:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:James@Flantec.com" class=""><span class="" style="color: rgb(0, 106, 227);">James@Flantec.com</span></a></span></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">mobile:<span class="Apple-tab-span" style="white-space: pre;"> </span>760-458-8498</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home: <span class="Apple-tab-span" style="white-space: pre;"> </span>219-221-6219</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span class="" style="color: rgb(121, 121, 121);">text:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:7604588498@txt.att.net" class=""><span class="" style="color: rgb(0, 106, 227);">7604588498@txt.att.net</span></a></span></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br class=""></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">aim:<span class="Apple-tab-span" style="white-space: pre;"> </span>Flantec</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">oovoo:<span class="Apple-tab-span" style="white-space: pre;"> </span>Flantec</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">Skype:<span class="Apple-tab-span" style="white-space: pre;"> </span>Flantec</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span class="" style="color: rgb(121, 121, 121);">ichat:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:Flantec@mac.com" class=""><span class="" style="color: rgb(0, 106, 227);">Flantec@mac.com</span></a></span></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br class=""></div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home:<span class="Apple-tab-span" style="white-space: pre;"> </span>1901 Cidermill Road</div><div class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><span class="Apple-tab-span" style="white-space: pre;"> </span>Michigan City, IN 46360</div>
</div>
<br class=""></body></html>