Assign the contents of a variable to a filename

[peteschulte]

Hello FoxPro Experts,

I want to use the contents of lcFilename to name or create a file and copy report numbers from a Db field to that file.

lcToday = dtos(Date())

lcFilename = lcToday + "_IVR"

? lcFilename

...displays 20081205_IVR. So far so good.

copy to \\Web\H\Remit\KEY\lcFilename SDF FIELDS email_conf FOR clientid = 'KEY' and !empty(confirmati) and posting_dt = Date()

Used this way or as 'lcFilename' with quotation marks, it still names the file lcFilename rather than 20081205_IVR. (SDF creates a System Data File with 51 chars/line and other characteristics.)

Any suggestions? I tried creating it locally with AR-PostingFile = fcreate(lcfilename) but it's just trading one variable for another, same problem.

With Rename I ran into the same problem of assigning the contents of the variable to the filename.
Thank you,
Peter

 

[peteschulte]

Here's what worked but left me with a new problem.

("\\Web\H\Remit\KEY\" + lcFilename)

--just the right combination of parens, quotes and the plus sign. Here is the full line.

copy to ("\\Web\H\Remit\KEY\" + lcFilename) SDF FIELDS email_conf FOR clientid = 'KEY' and !empty(confirmati) and posting_dt = Date()

Now, how can I make it do that and add NO FILE EXTENSION? This file is being created for FTP by an automated process. The absence of a file extension is a requirement. Otherwise it has to be done manually every day.

If you can help, thanks very much!
Peter

 

[JRB-Bldr]

Have you used the JUSTSTEM() command?

It should result in filename without the extension.

Good Luck,
JRB-Bldr

 

[Olaf Doschke]

I think copy to will always add ane xtension matching the type. How about RENAME after you generated the file?

Also adding a dot at the end of the file name without a furter extension works for me.

Bye, Olaf.

 

[Mike Lewis]

Peter,

Try adding a single dot to the end of the filename:

("\\Web\H\Remit\KEY\" + lcFilename [b] + "."[/b])

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[peteschulte]

Thanks to All,
I used your solution, Mike. It was the first one I tried!
Peter