import command with filename containing a variable

[James Flanagan]

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
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 11:48 AM, Chris Rendall via Filepro-list <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] 
> Sent: Tuesday, August 15, 2017 10:43 AM
> To: Chris Rendall <crendall at teamind.com>
> Cc: filePro (filepro-list at lists.celestial.com) <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
> 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/6f7efd94/attachment.html>