CODEWITHSUNDEEP
linuxbash
lfreez
lfreez

Reputation: 77

How to delete specific events log from log file in linux

I have a log file that size is more than 100MB

There are more than 1M lines below are 2 lines that in log file so I need to remove all lines beginning with "SMS2128301" (only in 4 th column in the line)

8,16/05/01 00:00:07,8801879887676,SMS2128301,0,0,0,1462039208274617,0,dummy,,5,6,,0,0,,1,0,27,0,0,0,,0,0,0,0,0,0,8801879887676,SMS2128301,,,

8,16/05/01 00:00:10,8801821094128,SMS2128301,0,0,0,1462039210395674,0,dummy,,5,6,,0,0,,1,0,41,0,0,0,,0,0,0,0,0,0,8801821094128,SMS2128301,,,

Upvotes: 1

Views: 579

Answers (1)

JayUK
JayUK

Reputation: 78

Have you tried somthing like this, but it would be slow I think:

SELECT * FROM table_name WHERE column_name LIKE '%SMS2128301%'

As a test to view, then upgade to DELETE when sure. Backup table first obviously!

EDIT Sorry miss read, thought it was MYSQL. What viewer are you using in Linux?

Upvotes: 1

Related Questions