How to replace colon in HH:MI:SS to hypen?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to replace colon in HH:MI:SS to hypen?
# 1  
Old 08-15-2014
How to replace colon in HH:MI:SS to hypen?

I have a file that contains timestamp in some of the rows in the file and the field separator is colon and some of the rows have numerical values, timestamp and characters with colon as the field separator
We are looking to change colon in HH:MI:SS for the timestamp to hyphen “-“ leaving the field separator untouched. Below is a sample data.

Code:

20189:wf_boat_extracts: invalid string: 20897:78:08/15/2014 10:20:54:state:country:

After formatting the data should be in this format.

Code:


20189:wf_boat_extracts: invalid string: 20897:78:08/15/2014 10-20-54:state:country:


Any suggestion will be really appreciated.

Thanks,
Cumeh1624
# 2  
Old 08-15-2014
Try:
Code:
sed 's/\( [0-2][0-9]\):\([0-5][0-9]\):\([0-9][0-9]\):/\1-\2-\3:/' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to print string after colon?

Hi How do I print character after colon":" below is input file BUC1 : 33157147, BUC1 COUNT : 478455,BUC1 : 9930334.18 BUC2 : 1203100,BUC2 COUNT : 318678,BUC2 GIVEN : 3493491.59 BUC3 : 234567.99 expected output 33157147 478455 9930334.18 12031002 318678 3493491.59 234567.99 (10 Replies)
Discussion started by: scriptor
10 Replies

2. Shell Programming and Scripting

Print after colon

I have entries like below in a file 11.22.33.44:80 22.33.44.55:81 :::587 :::465 What I need is to take out the part after colon ( : ) Output should be as follows. 80 81 587 465 I used cut -d: -f 2 but its not working as dedired. (2 Replies)
Discussion started by: anil510
2 Replies

3. Shell Programming and Scripting

Use of colon

There was a sample code on forum I found sometime back: $ f() { local foo=; : ${foo=unset}; declare -p foo; }; f declare -- foo="" $ f() { local foo; : ${foo=unset}; declare -p foo; }; f declare -- foo="unset" Can someone explain why was colon (:) is being used here. Whats its use? (4 Replies)
Discussion started by: Rameshck
4 Replies

4. UNIX for Dummies Questions & Answers

Why do we use a colon (:) in grep?

Can some one please explain why do we use colon in a grep statement . for eg: ORACLE_SID=$(grep :$(echo $JOBNAME |cut -c1-3): ${SWENV_TAB}|awk -F: '{print $1}') Thanks in advance Sri (5 Replies)
Discussion started by: Sri3001
5 Replies

5. UNIX for Advanced & Expert Users

Sequence number merged with hypen, shell script

Hello Folks, i have to write shell scripting for given expected output manner. in given input we have to write shell script in such a way that sequence no can b merged/link between start and end digit with hyphen "-" symbol and rest of digit separated by "," Eg : For Input "2 6 7 8 11 12... (9 Replies)
Discussion started by: panchalh
9 Replies

6. UNIX for Dummies Questions & Answers

Replace colon with blank space

Dear Gurus, I have a unix file with multiple colons on each row, and I would like to replace each colon with a blank space using the awk command. For example, I have the following data: Data: --------- A~000000000000518000~SLP:~99991231~20090701~00102.00~USD:~CS:~... (2 Replies)
Discussion started by: chumsky
2 Replies

7. Shell Programming and Scripting

Replace carriage return with colon on specific column

Hi, I have to process four source text files with possibility to contain carriage return on the particular column. Thus, i need to replace the carriage return with 3 colons <:::> The particular column position in the source files is not fix but the name is fixed. That is, say for example,... (4 Replies)
Discussion started by: agathaeleanor
4 Replies

8. UNIX for Dummies Questions & Answers

Purpose of - (hypen) in script or command line

Hi, I am new for unix and I am following ABS guide. What is the purpose of - (hypen ) in the below command and What it will do in this?. Can anyone explain it in detail. Rest of the things in the below command I understood somewhat. (cd /source/directory && tar cf - . ) | (cd /dest/directory &&... (1 Reply)
Discussion started by: gwgreen1
1 Replies

9. Shell Programming and Scripting

loop to replace txt and add command inside of colon (:)

in one of my script..I have some thing like john:christina : one:: and i want to make it like john:chritina:two:(date command):jackey: basically change 'one' to 'two' and run date :command and add other name: (30 Replies)
Discussion started by: Learnerabc
30 Replies

10. Solaris

how to delimit a colon

I want to know how to delimit a colon in a file name while scp ing from one host to other host. I used forward slash(\) but that is not working. (1 Reply)
Discussion started by: rogerben
1 Replies
Login or Register to Ask a Question