File name based on screen variable

[deanwarner]

I have created a csv but want to copy it and have the file name as a variable from a screen with the file extension csv.

Example

Variable on screen invno (entered by user eq 546701)
file created delivery.csv
want file name to be 546701.csv

Any help would be very much appreciated

 

[TheRambler]

if variable name = invno = 546701 then this should work:

RENAME delivery.csv TO (invno) + '.CSV'

 

[JRB-Bldr]

Remember that with non-Visual versions of Foxpro, your filename is limited to the 8.3 character format. No spaces, no long filenames, etc.

As long as your user's remember that or, if you do filename validity checking before attempting to use it, you should be fine.

Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com