<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Chris<div class=""><br class=""></div><div class="">40 is just a 6 digt .0 interger. </div><div class=""><br class=""></div><div class="">in debug mode, fn returns /tmp/addv/901458, as i would expect, but i see an added “.wp” as a file extension, but that is not in the fn variable. I have no idea where that is coming from. thank you</div><div class=""><br class=""></div><div class=""><div class="">*** A System Error Has Occurred ***</div><div class=""><br class=""></div><div class="">On File: /tmp/addv/901458.wp</div><div class=""><br class=""></div><div class="">Output Processing</div><div class="">Line Number: 56</div><div class=""><br class=""></div><div class="">import ascii data=(fn) r=\n f=: o=" c="</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">No such file or directory</div><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=""><div><blockquote type="cite" class=""><div class="">On Aug 15, 2017, at 11:48 AM, Chris Rendall via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" class="">filepro-list@lists.celestial.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">How is field 40 defined?<br class=""><br class="">How about this: fn="/tmp/addv/"{40{""<br class=""><br class="">I'm wondering if there are extra blanks in field 40 that are being included in the filename and causing the no such file or directory error.<br class=""><br class="">-- Chris<br class=""><br class=""><br class="">From: James Flanagan [<a href="mailto:James@Flantec.com" class="">mailto:James@Flantec.com</a>] <br class="">Sent: Tuesday, August 15, 2017 10:43 AM<br class="">To: Chris Rendall <<a href="mailto:crendall@teamind.com" class="">crendall@teamind.com</a>><br class="">Cc: filePro (<a href="mailto:filepro-list@lists.celestial.com" class="">filepro-list@lists.celestial.com</a>) <<a href="mailto:filepro-list@lists.celestial.com" class="">filepro-list@lists.celestial.com</a>><br class="">Subject: Re: import command with filename containing a variable<br class=""><br class="">Chris, <br class=""><br class="">I tried that, and i get the same error regarding no such file or directory. Thank you.<br class=""><br class="">James Flanagan<br class=""><a href="http://Flantec.com/" class="">http://Flantec.com/</a><br class=""><br class="">email:<span class="Apple-tab-span" style="white-space:pre"> </span>mailto:James@Flantec.com<br class="">mobile:<span class="Apple-tab-span" style="white-space:pre"> </span>760-458-8498<br class="">home: <span class="Apple-tab-span" style="white-space:pre"> </span>219-221-6219<br class="">text:<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>mailto:7604588498@txt.att.net<br class=""><br class="">aim:<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">oovoo:<span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">Skype:<span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">ichat:<span class="Apple-tab-span" style="white-space:pre"> </span>mailto:Flantec@mac.com<br class=""><br class="">home:<span class="Apple-tab-span" style="white-space:pre"> </span>1901 Cidermill Road<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Michigan City, IN 46360<br class=""><br class="">On Aug 15, 2017, at 11:37 AM, Chris Rendall via Filepro-list <mailto:filepro-list@lists.celestial.com> wrote:<br class=""><br class="">Try setting to a variable such as: fn="/tmp/addv/"{40<br class=""><br class="">Then for you import command use: import ascii data=(fn) r=\n f=^A o=" c="<br class=""><br class="">-- Chris<br class=""><br class="">-----Original Message-----<br class="">From: James Flanagan via Filepro-list [mailto:filepro-list@lists.celestial.com] <br class="">Sent: Tuesday, August 15, 2017 10:31 AM<br class="">To: Filepro_List <mailto:filepro-list@lists.celestial.com><br class="">Subject: import command with filename containing a variable<br class=""><br class="">I am trying to build a routine import command where the file name of the import would contain a respective variable of the record in am standing in. Because quotes are not used when defining the filename, i realize that i cannot just throw a variable in there. however, when i use parenthesis and quotes to attempt to achieve what i intend, it comes back with “NO SUCH FILE OR DIRECTORY”. Using the EXISTS command, and identical syntax as below, it returns that the file does indeed exist. <br class=""><br class="">Is there a way to inject a variable successfully into the filename of the import command? thank you very much, <br class=""><br class="">::import ascii data=("/tmp/addv/"{40) r=\n f=^A o=" c=":<br class=""><br class=""><br class="">James Flanagan<br class="">http://Flantec.com <http://flantec.com/><br class=""><br class="">email:<span class="Apple-tab-span" style="white-space:pre"> </span>mailto:James@Flantec.com <mailto:James@Flantec.com><br class="">mobile:<span class="Apple-tab-span" style="white-space:pre"> </span>760-458-8498<br class="">home: <span class="Apple-tab-span" style="white-space:pre"> </span>219-221-6219<br class="">text:<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>mailto:7604588498@txt.att.net <mailto:7604588498@txt.att.net><br class=""><br class="">aim:<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">oovoo:<span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">Skype:<span class="Apple-tab-span" style="white-space:pre"> </span>Flantec<br class="">ichat:<span class="Apple-tab-span" style="white-space:pre"> </span>mailto:Flantec@mac.com <mailto:Flantec@mac.com><br class=""><br class="">home:<span class="Apple-tab-span" style="white-space:pre"> </span>1901 Cidermill Road<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Michigan City, IN 46360<br class=""><br class="">-------------- next part --------------<br class="">An HTML attachment was scrubbed...<br class="">URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/1afb4f5f/attachment.html><br class="">_______________________________________________<br class="">Filepro-list mailing list<br class="">mailto:Filepro-list@lists.celestial.com<br class="">Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list<br class="">_______________________________________________<br class="">Filepro-list mailing list<br class="">mailto:Filepro-list@lists.celestial.com<br class="">Subscribe/Unsubscribe/Subscription Changes<br class="">http://mailman.celestial.com/mailman/listinfo/filepro-list<br class=""><br class="">_______________________________________________<br class="">Filepro-list mailing list<br class="">Filepro-list@lists.celestial.com<br class="">Subscribe/Unsubscribe/Subscription Changes<br class="">http://mailman.celestial.com/mailman/listinfo/filepro-list<br class=""></div></div></blockquote></div><br class=""></div></body></html>