Visit Our UNIX and Linux User Community


Display date in mm/dd/yy format in sed command


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Display date in mm/dd/yy format in sed command
# 1  
Old 03-04-2013
Display date in mm/dd/yy format in sed command

Hi All,

Following is my issue.

Code:
$MAIL_DOC = test.txt
test.txt contains the following text .

This process was executed in the  %INSTANCE% instance on %RUNDATE%.

Code:
I am trying to execute the following script
var=`echo $ORACLE_SID | tr [a-z] [A-Z]`
NOW=$(date +"%D")
sed -e "s/\%INSTANCE\%/$var/g;s/\%RUNDATE\%/$NOW/g" $MAIL_DOC

I am trying to display the current date in mm/dd/yy format.
Thats where the issue is .
If I try to display in mm-dd-yy format using date '+%m-%d-%Y' I do not have any issues.
But if I try to display in mm/dd/yy format using date +"%D" , I get sed command garbled.
Will sed command and date +"%D" format don't work ?
Please help.

Thanks
Megha.
# 2  
Old 03-04-2013
I've seen on some occasions that changing the delimiter for sed works:

Code:
export NOW=$(date '+%D')

echo "then" | sed "s/then/$NOW/"
sed: -e expression #1, char 13: unknown option to `s'

echo "then" | sed "s|then|$NOW|"
03/04/13

# 3  
Old 03-04-2013
Use a '#' sign for sed delimiter instead of a '/':
echo RUNDATE | sed "s#RUNDATE#$NOW#g"
This User Gave Thanks to spacebar For This Post:
# 4  
Old 03-04-2013
Thank you everyone for the prompt reply.
I changed the delimiter in the sed command to # and it worked.
Thanks again
Megha.

Previous Thread | Next Thread
Test Your Knowledge in Computers #2
Difficulty: Easy
Unix was invented by Steve Jobs of Apple Computer.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sed/awk command to convert number occurances into date format and club a set of lines

Hi, I have been stuck in this requirement where my file contains the below format. 20150812170500846959990854-25383-8.0.0 "ABC Report" hp96880 "4952" 20150812170501846959990854-25383-8.0.0 End of run 20150812060132846959990854-20495-8.0.0 "XYZ Report" vg76452 "1006962188"... (6 Replies)
Discussion started by: Chinmaya Kabi
6 Replies

2. Shell Programming and Scripting

Date command format

Hi, I need to convert a date format "August 12, 2013 9:40:00 PM CDT" in to DD/MM formant For example ..I am using ... date -d "January10, 2013 04:05:00 AM CST" +%m/%d which gives me... 01/10 However, when i'am using it against every month it is throwing errors on some months as... (3 Replies)
Discussion started by: Kevin Tivoli
3 Replies

3. Shell Programming and Scripting

sed command to replace slash in date format only

Hello experts. I haven't been able to find a solution for this using the sed command. I only want to replace the forward slash with string "FW_SLASH" only if there's a number right after the slash while preserving the original number. I have a file containing 2 entries: Original File:... (5 Replies)
Discussion started by: pchang
5 Replies

4. Emergency UNIX and Linux Support

Change the display format for ls -l command in AIX

Hi, I am using AIX 5.3. In my server if I list the file , I got the below result in below format. ********************************************* -rw-rw--w- 1 letapp1 staff 0 Jun 8 02:53 CC00030710.cntrl ********************************************* But now I am seeing... (22 Replies)
Discussion started by: puni
22 Replies

5. Shell Programming and Scripting

Format of SED command to change a date

I have a website. I have a directory within it with over a hundred .html files. I need to change a date within every file. I don't have an easy way to find/replace. I need to change 10/31 to 11/30 on every single page at once. I tried the command below but it didn't work. Obviously I don't know... (3 Replies)
Discussion started by: ijustsawmars
3 Replies

6. UNIX for Dummies Questions & Answers

Date format Display Help

I have tried various arguments to get the date display as "Mar 10". I have tried date +"%c" -------> Wed Mar 10 11:51:21 EST 2010 date +"%b%d%Y_%H%M%S" --------> Mar102010_115121 date +"%b%d" -------> Mar10 date +"%t%b%e" ... (3 Replies)
Discussion started by: moveaix
3 Replies

7. HP-UX

Date format of ll command

Hi, Unix: HP-UNIX. I have a requirement(part of my requirement) to get latest file modification date of all files(In a particular directory). Using ll comand i m able to find out the modification date but not in the required format My command and out put: echo trp_pb.sql `ll... (2 Replies)
Discussion started by: satyadash
2 Replies

8. UNIX for Dummies Questions & Answers

Date Display Format

Hello People, How can I display the date in a continuous format along with the time as below : 20091001_154547 i.e yyyymmdd_hhmmss format. Thanks. (3 Replies)
Discussion started by: sushant172
3 Replies

9. Shell Programming and Scripting

ls command format display

Hi I have 3 files $ ls -l -rw-r--r-- 1 osbadmin osbadmin 427701 Apr 22 12:06 SANITY_TEST -rw-r--r-- 1 osbadmin osbadmin 427701 Apr 22 12:06 Success 123333 -rw-r--r-- 1 osbadmin osbadmin 427701 Apr 22 12:06 Success 123333 (1) I need to see this "SANITY_TEST" "Success 123333" "Success... (6 Replies)
Discussion started by: mnmonu
6 Replies

10. Shell Programming and Scripting

sed to display date in dd/mm/yyyy format

Hi I have a sed command sed -e "s/sub_date/=$(date +"%d/%m/%Y")/" sub_create_tmp I want to substitute with the current date in dd/mm/yyyy format . But the result is an error " cannot parse " . Pls help . sars (2 Replies)
Discussion started by: sars
2 Replies

Featured Tech Videos