Help needed in scripting

Shell Programming and Scripting
1

Hi Guys,

I need help in scripting out the below :

this is a sample data i have in my file:

jobname type 8:00:00 AM

I need to remove the ":00" from the time field alone.

Thanks in advance for all ur help

2 
sed 's/:00//g'  <filename>

should help

3

Hi,

I missed one thing i need to replace only the ":00" in the seconds column alone

Thanks

4

In awk set the FS to ":" and then substitute the $3 field.

5 
cat filename | awk -F ":" '{print $1":"$2":"$3}' >>new.file

replace $3 with your requirement in ""

6 
cat filename | awk -F ":" '{print $1":"$2 ", substr($3,3)}' >>new.file

will give the required result

7

Hi isubodh,

The command u gave is thowing an error

awk: {print $1":"$2 " substr($3,2)}
awk: ^ unterminated string

8

Remove the third double quote:

awk: {print $1":"$2 " substr($3,2)}
1 Like
9 
cat filename | awk -F ":" '{print $1":"$2, substr($3,3)}' >>new.file