Remove unwanted characters

[mrcuser]

I have the following strings of data:

07/15/09 19:00:00,07/15/09 19:14:35,1900-WKDAY_INC,KN-ECS,Failed 12
07/15/09 20:00:00,,2000_INC,KN2-DIA-P0001,Missed

but only need the following:

07/15/09 1900-WKDAY_INC,KN-ECS,Failed 12
07/15/09 2000_INC,KN2-DIA-P0001,Missed

When I try to awk out the relevant parts using $2 it hit errors as $2 sees the 20:00:00,,2000_INC,KN2-DIA-P0001,Missed as one column so ignores the whole string. Anyway to correct this ?

 

[feherke]

Hi

Anyway to correct this ?

Then why not posted that code ?

Feherke.

http://rootshell.be/~feherke/

 

[LKBrwnDBA]

Try:

cut -d',' -f 3- <data_file >out_file

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[feherke]

Hi

Anyway. This produces the desired output :

awk '{sub(/  .*:[0-9][0-9],+/,"  ")}1' /input/file

Tested with [tt]gawk[/tt] and [tt]mawk[/tt].


Feherke.

http://rootshell.be/~feherke/

 

[mrcuser]

Sorry I didn't paste the code as it was a simple

cat file|awk '{print $1,$2}' grep -v :

Thanks for the solution i'll try that now....