Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Split Date/time data to two

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Split Date/time data to two
# 1  
Old 11-11-2010
Split Date/time data to two
Hi all,

I have logs(in a log file) with the following structure
Code:
20100916011501559;0.812;null;TRUE;;FALSE;0.812;0;0;;19
20100916011504762;0.015;null;TRUE;;FALSE;0;4|4;0.015;;4
20100916011504762;0;null;TRUE;;FALSE;0;0;0;;4
20100916011501731;3.343;null;TRUE;;FALSE;3.156;131|65;0.172;;11
20100916011501731;3.156;null;TRUE;;FALSE;3.156;0;0;;11

I want to split the first date time format to a readable format
Code:
2010/09/16;01:15:01:559;0.812;null;TRUE;;FALSE;0.812;0;0;;19
2010/09/16;01:15:04:762;0.015;null;TRUE;;FALSE;0;4|4;0.015;;4
2010/09/16;01:15:04:762;0;null;TRUE;;FALSE;0;0;0;;4
2010/09/16;01:15:01:731;3.343;null;TRUE;;FALSE;3.156;131|65;0.172;;11
2010/09/16;01:15:01:731;3.156;null;TRUE;;FALSE;3.156;0;0;;11

is there any simple way to do this (using sed??)

thanks
babai
Last edited by Franklin52; 11-11-2010 at 09:09 AM.. Reason: Please use code tags!
# 2  
Old 11-11-2010
Try:
Code:
sed 's|\(....\)\(..\)\(..\)\(..\)\(..\)\(..\)|\1/\2/\3;\4:\5:\6:|' infile

These 3 Users Gave Thanks to Scrutinizer For This Post:
babai gc_sw phoenix_nebula
# 3  
Old 11-11-2010
Code:
awk -F "" '{$4=$4"/";$6="/";$8=$8";";$10=$10":";$12=$12":";$14=$14":"}1' OFS="" infile

This User Gave Thanks to rdcwayx For This Post:
babai
# 4  
Old 11-11-2010
SED cmd works fine, Thanks alot

---------- Post updated at 02:24 PM ---------- Previous update was at 02:14 PM ----------

After performing the above cmd, i am adding another text to each line like this using sed
Code:
sed "s/^/systemname_instancename;/" logs.out

systemname_instancename;2010/09/16;01:15:01:559;0.812;null;TRUE;;FALSE;0.812;0;0;;19
systemname_instancename;2010/09/16;01:15:04:762;0.015;null;TRUE;;FALSE;0;4|4;0.015;;4
systemname_instancename;2010/09/16;01:15:04:762;0;null;TRUE;;FALSE;0;0;0;;4
systemname_instancename;2010/09/16;01:15:01:731;3.343;null;TRUE;;FALSE;3.156;131|65;0.172;;11
systemname_instancename;2010/09/16;01:15:01:731;3.156;null;TRUE;;FALSE;3.156;0;0;;11
systemname_instancename;

end of the log file there is blank line is also added with

systemname_instancename;

is there anyway to avoid this???
Last edited by Scott; 11-15-2010 at 05:15 AM.. Reason: Code tags, please...
# 5  
Old 11-11-2010
You could add it to the first statement:
Code:
sed 's|\(....\)\(..\)\(..\)\(..\)\(..\)\(..\)|systemname_instancename;\1/\2/\3;\4:\5:\6:|' infile

This User Gave Thanks to Scrutinizer For This Post:
gc_sw
# 6  
Old 11-11-2010
You are the best
Last edited by vbe; 11-11-2010 at 10:28 AM.. Reason: (don't write in cyberchat or cyberpunk style). English only.
# 7  
Old 11-11-2010
correction to the awk command

Code:
awk -F "" '{$4=$4"/";$6=$6"/";$8=$8";";$10=$10":";$12=$12":";$14=$14":"}1' OFS="" infile
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting data file by date and time

Hello. Sorting data file by date and time with the following issues: Date is in the following format m/d/yyyy, no leading zeros Time is in the following format h:m:s AM/PM, no leading zeros Any ideas on how to sort data when the above issues? Could the date/time be converted inline to... (5 Replies)
Discussion started by: JimBurns
5 Replies

2. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ... (6 Replies)
Discussion started by: Showdown
6 Replies

3. Shell Programming and Scripting

[Solved] How to tar data along with current system date and time.?

Hi all, Following is my small script:- #!/bin/ksh for i in `cat /users/jack/mainfile-dr.txt` do sudo cp -r $i /users/jack/DR01/. done cd /users/jack/DR01/ sudo tar cvf system1-DR.tar * scp system1-DR.tar backupserver:/DRFiles/system1 sudo rm -rf system1-DR.tar In this script I... (10 Replies)
Discussion started by: manalisharmabe
10 Replies

4. Shell Programming and Scripting

Adding time to date time in UNIX shell scipting

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as... (3 Replies)
Discussion started by: codehelp04
3 Replies

5. Solaris

modifying date and time and time zone on solaris 5.10 with (redundant server) veritas

I have a cluster of two Solaris server (veritas cluster). one working and the other is standby I am going to change the date on them , and am looking for a secure solution as it is giving an important service. my opinion is that the active one doesn't need to be restarted (if I don't change the... (1 Reply)
Discussion started by: barry1946
1 Replies

6. UNIX for Dummies Questions & Answers

Converting string date time to unix time in AWK

I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk. I tried This is how each line of the file looks like, different date and time in this format Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th ... (2 Replies)
Discussion started by: bkkid
2 Replies

7. Shell Programming and Scripting

compare date and time inside data of two files

i have two files with identical no of columns. 6th columns is date (MM/DD/YY format) and 7th columns is time (HH:MM:SS) format. I need to compare these two vaules and if the date & time is higher than fileA, save it on fileC; if the value is lower, then save it on fileD CONDITIONS... (7 Replies)
Discussion started by: ajiwww
7 Replies

8. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

9. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

10. Shell Programming and Scripting

To extract data of a perticular interval (date-time wise)

I want a shell script which extract data from a log file which contains date and time-wise data and i need the data for a perticular interval of time...what can i do??? (3 Replies)
Discussion started by: abhishek27
3 Replies
Login or Register to Ask a Question