Visit Our UNIX and Linux User Community


Convert DATE string to a formatted text


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert DATE string to a formatted text
# 1  
Old 10-09-2007
Convert DATE string to a formatted text

Hi guys, i need your help.

I need to convert a date like this one 20071003071023 , to a formated date
like 20071003 07:10:23 .

Could this be possible ?

Regards,

Osramos
# 2  
Old 10-09-2007
Code:
# echo "20071003071023" | awk '{print substr($0,1,8)" "substr($0,9,2)":"substr($0,11,2)":"substr($0,13,2)}'
20071003 07:10:23

# 3  
Old 10-09-2007
Code:
echo 20071003071023 | sed 's/\(..\)\(..\)\(..\)$/ \1:\2:\3/'

# 4  
Old 10-10-2007
Converte DATE string to a formated text - Part2

Hello,

thanks to all who help me, but i make a mystake .

I've got this piece of file

APPLICATION GROUP_NAME MEMNAME ODATE STATUS START_TIME END_TIME


-------------------- -------------------- ------------------------------ ------ ---------------- -------------- --------------


AFT AFTSCMDIVD AFTDIVD1312A 071001 Ended OK 20071002041242 20071002041242

AFT AFTSCMDIVD AFTDIVD0115B 071002 Ended OK 20071003063253 20071003063303

and i want to convert to this :



APPLICATION GROUP_NAME MEMNAME ODATE STATUS START_TIME END_TIME


-------------------- -------------------- ------------------------------ ------ ---------------- -------------- --------------


AFT AFTSCMDIVD AFTDIVD1312A 071001 Ended OK 20071002 04:12:42 20071002 04:12:42

AFT AFTSCMDIVD AFTDIVD0115B 071002 Ended OK 20071003 06:32:53 20071003 06:33:03


like i've told before , all i need is to format the date and time, but i need to have also the file output with all de information.

Is it possible or is more complicated
# 5  
Old 10-10-2007
Have you tried the sed command I provided? It will format the last occurrence, you can easily extent that to cover the date in the second to last field.
# 6  
Old 10-10-2007
Hi, yes i have tried with you sed command like this :
Code:
cat report_jobs_CTM.csv | awk '{print $7 $8}' |sed 's/\(..\)\(..\)\(..\)$/ \1:\2:\3/' > new.csv

but the the result was this:

EN D_:TI:ME
-------- --:--:--
2007100204124220071002 04:12:42
2007100204124820071002 04:12:48

Why i am doing wrong ?

Last edited by Yogesh Sawant; 05-20-2010 at 11:33 AM.. Reason: added code tags
# 7  
Old 10-10-2007
Code:
awk '{ 
     for(i=7;i<=8;i++) {
       $i=substr($i,1,8)" "substr($i,9,2)":"substr($i,11,2)":"substr($i,13,2)
     }
     {print}
}' "file"


Previous Thread | Next Thread
Test Your Knowledge in Computers #140
Difficulty: Easy
Unix and the C programming language were both developed at AT&T.
True or False?

9 More Discussions You Might Find Interesting

1. Solaris

Convert string (YYYYMMDD) format to date in Sun OS

Hi All I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated. The date command usage from the operating system we use here is as follows: Thanks, SK (11 Replies)
Discussion started by: SK123
11 Replies

2. Shell Programming and Scripting

Convert string to date and add 20 days

Hi, I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220. In case of 20170228, it should show 20170320. Could you please help me with the command to achieve this. Note: I am using AIX 7.1... (5 Replies)
Discussion started by: satyaatcgi
5 Replies

3. Shell Programming and Scripting

Convert string to date and add 1 hours

i have some set of date data inside csv files and need to convert the timezone, 08302016113611861 08302016113623442 08302016113541570 08302016113557732 08302016113548439 08302016112853115 08302016113620684 08302016113432827 08302016113630321 date format is : %m%d%Y%H%M%Smilisec ... (2 Replies)
Discussion started by: before4
2 Replies

4. Shell Programming and Scripting

Convert string into date format

Hi, I am getting the below string as a input for date. 12/03/2013 11:02 AM I want to change this date as 03-DEC-2013 11:02 AM. Could you please help on this. Thanks Chelladurai (4 Replies)
Discussion started by: ckchelladurai
4 Replies

5. Emergency UNIX and Linux Support

Convert string to date and add 1

Hi All, I want to convert string in format YYYYMMDD(20120607) to date in unix and add 1 day to it and convert back to string in format YYYYMMDD. Please help. (4 Replies)
Discussion started by: cns1710
4 Replies

6. Shell Programming and Scripting

String searching and output to a file in a formatted text

Hi, I'm very new to UNIX scripting and find quite difficult to understand simple UNIX syntax. Really appreciat if somebody could help me to give simple codes for my below problems:- 1) I need to search for a string "TTOH 8031950001" in a files which filename will be "*host*'. For example, the... (3 Replies)
Discussion started by: cuji
3 Replies

7. AIX

Convert string to date in script

Hi, How can I convert a string "Jul 10 09" to date in aix? the output can be like 20090710. Thanks. (4 Replies)
Discussion started by: Gbyte
4 Replies

8. Shell Programming and Scripting

Convert String to Date Unix

Hi people, I need to convert a string eg 09/13/2008 to a valid unix date. (4 Replies)
Discussion started by: sameerspice
4 Replies

9. Shell Programming and Scripting

Convert String to Date

Hi, I have a String input parameter like this: 20080430 (YYYYMMDD). Inside my korn shell script I need to add one day to this date. L_TRADE_DAY=$1 let L_TODAY=$L_TRADE_DAY+1 Offcourse this raises a problem at the end of a month. 20080430 + 1 gives 20080431 instead of 20080501. ... (2 Replies)
Discussion started by: ORatjeuh
2 Replies

Featured Tech Videos