filename concatenation

Computing.Net > Forums > Database > filename concatenation

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

Original Message

Name: shk_imran
Date: October 8, 2008 at 01:07:17 Pacific
Subject: filename concatenation
OS: Win 2000
CPU/Ram: 512

Comment:

I have been successful fifty percent in my requirement. i worte this syntax
EXP userid=scott/manager owner=scott rows=y file=c:\BCP_SCOTT_%DATE%
and getting export file with name according to current day of date like:

BCP_SCOTT_Mon
BCP_SCOTT_Tue
BCP_SCOTT_Wed
BCP_SCOTT_Thu
BCP_SCOTT_Fri
BCP_SCOTT_Sat
BCP_SCOTT_Sun
but i want export file with names like
BCP_SCOTT_Mon_06_10_2008
BCP_SCOTT_Tue_07_10_2008
BCP_SCOTT_Wed_08_10_2008
BCP_SCOTT_Thu_09_10_2008
BCP_SCOTT_Fri_10_10_2008
BCP_SCOTT_Sat _11_10_2008
BCP_SCOTT_Sun_12_10_2008
So please tell me how i can add/concatenate this(_05_10_2008) in filename.. ?????????????????
Regards to all friends

Report Offensive Message For Removal

Response Number 1

Name: Elinor
Date: November 14, 2008 at 15:46:22 Pacific

Reply:

Hi,
Have you tried something like:
EXP userid=scott/manager owner=scott rows=y file=c:\BCP_SCOTT_%date:~11%_%date:~8,2%_%date:~5,2%
?
Date format can vary so it may need a little tweaking.
Hth,
Elinor
Elinor Hurst
http://elinorhurst.blogspot.com

Report Offensive Follow Up For Removal

Response Number 2

Name: shk_imran
Date: November 16, 2008 at 22:48:36 Pacific

Reply:

Hi Elinor Hurst,
i am very thankful to you. you solved my problem. again thanx.
Regards,
Imran

Report Offensive Follow Up For Removal


filename concatenation plsql how to concatenate the filename with system date and time XP batch find filename wildcards	unix filename date increment filename in dos awk filename