Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Changing the date format in a script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Changing the date format in a script
# 1  
Old 12-20-2010
Changing the date format in a script
Hi,

I run a script which outputs various records, anyway one of the columns contains the date in the format DDMMYYYY, I would like to make this DDMMYY.

Is there an easy way to do this,
# 2  
Old 12-20-2010
Removed.
Last edited by anurag.singh; 12-20-2010 at 07:18 AM..
# 3  
Old 12-20-2010
I think I need a bit more explaining., I think I have found an easier solution.

Here is a sample record:
Code:
C,999999,5612,13122010,C,RANDOMD CHARACTERS,ND
C,999999,17140,13122010,C,MORE RANDOM STUFF,ND

I records lengths change, however the date will always be 4th column. This is extracted from a database and I need to remove the millenia year - I.e So it displays 131210 instead of 13122010...
Code:
C,999999,5612,131210,C,RANDOMD CHARACTERS,ND
C,999999,17140,131210,C,MORE RANDOM STUFF,ND

Thanks
# 4  
Old 12-20-2010
Code:
sed 's/,\([0-9]{4}\)[0-9]{2}\([0-9]{2}\),/\1\2/g' inputfile

Matching a 8 digits number between two ,(comma) and remembering first 4 + last 2 digits of it to exclude 2 unwanted middle digits.
Last edited by R0H0N; 12-20-2010 at 07:06 AM..
This User Gave Thanks to For This Post:
mcclunyboy
R0H0N
# 5  
Old 12-20-2010
Can you run through the command explaining , I can read most of it and understand it but it doesn't seem to be working...
# 6  
Old 12-20-2010
Edited Post#4
R0H0N
# 7  
Old 12-20-2010
which part makes can make it use only the 4th column, I tested the command and it does work perfectly it just doesnt work on the extract as it isn't using the 4th (or am i missing this..)

I appreciate your help
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Changing date format with script

I'm trying to change date format using this script from day/month/year to month/day/year #!/bin/bash while read line; do echo "$line" date=$(echo "$line" | cut -d/ -f1 ) month=$(echo "$line" | cut -d/ -f2 ) echo $month"/"$date"/2017" done < ~/Downloads/Dates.csv But I get output as... (5 Replies)
Discussion started by: sharat
5 Replies

2. Shell Programming and Scripting

Changing date format

how do i change the following to show me what the date was 7 days ago? date +%Y-%m-%d (1 Reply)
Discussion started by: SkySmart
1 Replies

3. Shell Programming and Scripting

Changing the date format

Hi all, I have a file with below data af23b|11-FEB-12|acc7 ad23b|12-JAN-12|acc4 as23b|15-DEC-11|acc5 z123b|18-FEB-12|acc1 I need the output as below:-(date in yyyymmdd format) af23b|20120211|acc7 ad23b|20120112|acc4 as23b|20111215|acc5 z123b|20120218|acc1 Please help me on this.... (7 Replies)
Discussion started by: gani_85
7 Replies

4. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

5. Shell Programming and Scripting

Changing Date format

How to change a date stored in a variable to YYYYMMDD. Variable output is in DD-MON-YY,required format is 'YYYYMMDD' Thanks, Sud (1 Reply)
Discussion started by: sud
1 Replies

6. Shell Programming and Scripting

Changing date format

Hi, I have a column in a table of Timestamp datatype. For Example : Var1 is the column 2008-06-26-10.10.30.2006. I have Given query as date(var1) and time (var1) I got the file as in the below format : File1: Col1 Col2 2008-06-02|12.36.06 2008-06-01|23.36.35 But the problem is... (7 Replies)
Discussion started by: manneni prakash
7 Replies

7. Post Here to Contact Site Administrators and Moderators

changing the format of date

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (1 Reply)
Discussion started by: nasirgondal
1 Replies

8. UNIX for Dummies Questions & Answers

Changing the format of date

Hi, There are lots of threads about how to manipulate the date using date +%m %....... But how can I change the default format of the commad date? $ date Mon Apr 10 10:57:15 BST 2006 This would be on fedora and SunOs. Cheers, Neil (4 Replies)
Discussion started by: nhatch
4 Replies

9. Shell Programming and Scripting

Changing date format

Hi, Is there any way to change one date format to another ?? I mean I have a file having dates in the format (Thu Sep 29 2005) ... and i wud like to change these to YYYYMMDD format .. is there any command which does so ?? Or anything like enum which we have in C ?? Thanks in advance, ... (5 Replies)
Discussion started by: Sabari Nath S
5 Replies

10. Shell Programming and Scripting

Changing the date format

Hi, I know there is a Q/A section and lots of posts regarding date command here. I am sorry to start a new thread. I am very new to shell scripting (actually i am working on my first program), so please forgive my ignorance. I could not find an answer to my problem else where so i posted it... (10 Replies)
Discussion started by: Dream86
10 Replies
Login or Register to Ask a Question