import command with filename containing a variable
James Flanagan
James at Flantec.com
Tue Aug 15 09:31:23 PDT 2017
Thank you everyone.
apparently the PFADDWP not being set to OFF was the issue. I was not familiar with that variable bofore, but now i am. thank you very much,
James Flanagan
Flantec.com <http://flantec.com/>
email: James at Flantec.com <mailto:James at Flantec.com>
mobile: 760-458-8498
home: 219-221-6219
text: 7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>
aim: Flantec
oovoo: Flantec
Skype: Flantec
ichat: Flantec at mac.com <mailto:Flantec at mac.com>
home: 1901 Cidermill Road
Michigan City, IN 46360
> On Aug 15, 2017, at 12:17 PM, Chris Rendall via Filepro-list <filepro-list at lists.celestial.com> wrote:
>
> James,
>
> I think filePro automatically adds in the .wp if you don't specify a file extension.
>
> Try setting the environment variable PFADDWP=OFF to prevent that.
>
> -- Chris
>
> From: James Flanagan [mailto:James at Flantec.com <mailto:James at Flantec.com>]
> Sent: Tuesday, August 15, 2017 11:10 AM
> To: Chris Rendall <crendall at teamind.com <mailto:crendall at teamind.com>>
> Cc: filePro (filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>) <filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>>
> Subject: Re: import command with filename containing a variable
>
> Chris
>
> 40 is just a 6 digt .0 interger.
>
> 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
>
> *** A System Error Has Occurred ***
>
> On File: /tmp/addv/901458.wp
>
> Output Processing
> Line Number: 56
>
> import ascii data=(fn) r=\n f=: o=" c="
>
>
> No such file or directory
>
> James Flanagan
> http://Flantec.com/ <http://flantec.com/>
>
> email: mailto:James at Flantec.com <mailto:James at Flantec.com>
> mobile: 760-458-8498
> home: 219-221-6219
> text: mailto:7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>
>
> aim: Flantec
> oovoo: Flantec
> Skype: Flantec
> ichat: mailto:Flantec at mac.com <mailto:Flantec at mac.com>
>
> home: 1901 Cidermill Road
> Michigan City, IN 46360
>
> On Aug 15, 2017, at 11:48 AM, Chris Rendall via Filepro-list <mailto:filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>> wrote:
>
> How is field 40 defined?
>
> How about this: fn="/tmp/addv/"{40{""
>
> 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.
>
> -- Chris
>
>
> From: James Flanagan [mailto:James at Flantec.com <mailto:James at Flantec.com>]
> Sent: Tuesday, August 15, 2017 10:43 AM
> To: Chris Rendall <mailto:crendall at teamind.com <mailto:crendall at teamind.com>>
> Cc: filePro (mailto:filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>) <mailto:filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>>
> Subject: Re: import command with filename containing a variable
>
> Chris,
>
> I tried that, and i get the same error regarding no such file or directory. Thank you.
>
> James Flanagan
> http://Flantec.com/
>
> email: mailto:James at Flantec.com
> mobile: 760-458-8498
> home: 219-221-6219
> text: mailto:7604588498 at txt.att.net
>
> aim: Flantec
> oovoo: Flantec
> Skype: Flantec
> ichat: mailto:Flantec at mac.com
>
> home: 1901 Cidermill Road
> Michigan City, IN 46360
>
> On Aug 15, 2017, at 11:37 AM, Chris Rendall via Filepro-list <mailto:filepro-list at lists.celestial.com> wrote:
>
> Try setting to a variable such as: fn="/tmp/addv/"{40
>
> Then for you import command use: import ascii data=(fn) r=\n f=^A o=" c="
>
> -- Chris
>
> -----Original Message-----
> From: James Flanagan via Filepro-list [mailto:filepro-list at lists.celestial.com]
> Sent: Tuesday, August 15, 2017 10:31 AM
> To: Filepro_List <mailto:filepro-list at lists.celestial.com>
> Subject: import command with filename containing a variable
>
> 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.
>
> Is there a way to inject a variable successfully into the filename of the import command? thank you very much,
>
> ::import ascii data=("/tmp/addv/"{40) r=\n f=^A o=" c=":
>
>
> James Flanagan
> http://Flantec.com <http://flantec.com/>
>
> email: mailto:James at Flantec.com <mailto:James at Flantec.com>
> mobile: 760-458-8498
> home: 219-221-6219
> text: mailto:7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>
>
> aim: Flantec
> oovoo: Flantec
> Skype: Flantec
> ichat: mailto:Flantec at mac.com <mailto:Flantec at mac.com>
>
> home: 1901 Cidermill Road
> Michigan City, IN 46360
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/1afb4f5f/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com <mailto:Filepro-list at lists.celestial.com>
> Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list <http://mailman.celestial.com/mailman/listinfo/filepro-list>
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/9fea3d10/attachment.html>
More information about the Filepro-list
mailing list