I don't like resetting my date so I would do the following set var cfafil text = 'csd1invoice_' set var filnam text = (.cfafil+(ctxt(format(.#date,'mmddyy')))+'.dat')
Buddy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Ratliff Sent: Thursday, September 05, 2002 12:14 PM To: [EMAIL PROTECTED] Subject: RE: Here is the syntax I used to test Claudine's solution: set date mmddyy set var cfafil text = 'csd1invoice_' set var filnam text = (.cfafil+(ctxt(#date))+'.dat') out .filnam unl dat for buyers out scr This created a file from the BUYERS table with the name CSD1INVOICE_090502.DAT This is exactly what I needed! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of J. Stephen Wills Sent: Thursday, September 05, 2002 8:42 AM To: [EMAIL PROTECTED] Subject: Re: Shouldn't it be either CTXT(.#DATE) or &#DATE? Steve in Memphis ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 10:29 AM Subject: RE: > Sorry, I should've written: > > SET VAR var1 = "CSD1INVOICE_" > SET VAR filename = (.var1 + #date + ".dat") > OUT .filename > > Claudine :) > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 9:25 AM > > To: [EMAIL PROTECTED] > > Subject: > > > > > > > > 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/ ================================================ 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/ ================================================ 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/
