Convert DATE string to a formatted text

osramos · #1 (**permalink**) 10-09-2007

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

ghostdog74 · #2 (**permalink**) 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

reborg · #3 (**permalink**) 10-09-2007

Code:

echo 20071003071023 | sed 's/\(..\)\(..\)\(..\)$/ \1:\2:\3/'

osramos · #4 (**permalink**) 10-10-2007

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

reborg · #5 (**permalink**) 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.

osramos · #6 (**permalink**) 10-10-2007

Hi, yes i have tried with you sed command like this :

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 ?

ghostdog74 · #7 (**permalink**) 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"

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Convert String to Date	ORatjeuh	Shell Programming and Scripting	2	05-06-2008 06:49 AM
Mutt - Word Document or Formatted text as a Message	krsenkumar	UNIX for Advanced & Expert Users	1	04-05-2008 11:10 AM
find formatted filename with date time	dpath2o	UNIX for Advanced & Expert Users	6	02-05-2008 11:20 PM
convert Julian date to calender date	srikanthus2002	Shell Programming and Scripting	6	05-08-2007 06:27 AM
How do I convert unix text to to win text?	nucca	UNIX for Dummies Questions & Answers	1	06-25-2001 02:30 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by