David, Try the following to create you file name: SET VAR YY TEXT = ((FORMAT(.#DATE,'CSD1INVOICE_YYMMDD'))+'.EXT')
If you wish a different sequence for the date cahange to "_MMDDYY". You can substitute any variable that is a DATE type for the #DATE. Replace ".EXT" with you chosen file name extension. -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- "David Ratliff" <[EMAIL PROTECTED]> wrote: > > > To anyone out there?! > > I am working on an interface exporting data from RBASE > 6.1 as an > ASCII delimited file to a 3rd party app. The 3rd party app requires > the > filename contain an 18 character name with a 3 character extension. > > The 3rd party app requires I use the system date as > the unique ID > for the last 6 characters of the filename. I can not figure > out how to > precede my 6 character filename with the 12 additional characters > (CSD1INVOICE_). > Once the job is complete I will have created an ASCII > delimited file > using the name CSD1INVOICE_######.DAT where ###### is the current > date of > the export (unique ID) out of RBASE. > Any ideas how I might achieve a rename from short to > long from RBASE > or DOS batch? I have tried XCOPY in a DOS batch file but that > seems to work > only if I append the 12 additional characters. Unfortunately > I need them to > precede the RBASE output filename. This is the last step in > the design and > must be automated for the user. > > Thanks, > > David R. > Pine, Arizona > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
