[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Renaming oubound file
- Subject: RE: [sqr-users] Renaming oubound file
- From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
- Date: Wed, 17 Nov 2004 11:23:15 -0800
- Delivery-date: Wed, 17 Nov 2004 14:26:21 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
You can't append the date to the end of the file name; extensions are only
three characters. You want to insert the date before the last period in the
filename string.
-----Original Message-----
From: radhika reddy [mailto:radhika_05@hotmail.com]
Sent: Wednesday, November 17, 2004 11:19 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Renaming oubound file
Hi,
I am trying to rename my outbound file from Training.txt to
Trainingxxxxxxxx where x's is MMDDYYYY. i am trying to do something like
this:
LET $SYSTEMDATE = EDIT(SUBSTR($sysdatetime,1,11),'MMDDYYYY')
display $SYSTEMDATE ! here i am able to get
11172004
let #ret_cd = rename($File2,$NEW_FILENAME)
if #ret_cd <> 0
show 'Error Renaming ' $File2 ' to ' $New_fileName ' Ret_cd = '
#ret_cd
end-if
where my $file2 is 'C:\Documents and Settings\lkra\Desktop\Training.txt'.
I am getting the following error:-
ERROR Renaming C:\Documents and Settings\lkra\Desktop\Training.txt to
C:\Documents and Settings\lkra\Desktop\Training.txt11172004 Ret_cd =
13.000000
Thanks
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users