Perl Delete multiple lines from csv file beginning with specific string

Question

I have a csv file having data as below format.

09:20:02.063,110.600,110.300,110.600
09:20:08.425,111.600,110.300,110.600
09:21:02.684,111.600,110.300,110.600
09:21:03.188,110.600,110.300,110.600
09:22:05.552,110.600,110.300,110.600
09:22:03.914,113.600,110.300,110.600
09:23:04.282,112.600,110.300,110.600
09:23:05.643,111.600,110.300,110.600
09:24:01.004,111.600,110.300,110.600
09:24:05.369,110.600,110.300,110.600

What I want to do is to remove the entire rows that beginning as “09:23”, However the data format consist of Hour:Minute:Second.Millisecond. It is difficult for me to using Perl to just specific “Hour:Minute” to remove the rows. Any advice, Thanks

Expected result

09:20:02.063,110.600,110.300,110.600
09:20:08.425,111.600,110.300,110.600
09:21:02.684,111.600,110.300,110.600
09:21:03.188,110.600,110.300,110.600
09:22:05.552,110.600,110.300,110.600
09:22:03.914,113.600,110.300,110.600
09:24:01.004,111.600,110.300,110.600
09:24:05.369,110.600,110.300,110.600

Since you're new to Stack Overflow, i suggest you to read this — Avinash Raj
– Avinash Raj, Commented Jul 12, 2015 at 13:48

Avinash Raj · Accepted Answer · 2015-07-12 13:35:59Z

1

You may try this,

$ perl -lne 'print if !/^09:23\b/' file
09:20:02.063,110.600,110.300,110.600
09:20:08.425,111.600,110.300,110.600
09:21:02.684,111.600,110.300,110.600
09:21:03.188,110.600,110.300,110.600
09:22:05.552,110.600,110.300,110.600
09:22:03.914,113.600,110.300,110.600
09:24:01.004,111.600,110.300,110.600
09:24:05.369,110.600,110.300,110.600

Or

With grep,

grep -v '^09:23\b' file

answered Jul 12, 2015 at 13:35

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Avinash Raj Over a year ago

or perl -ne 'print if !/^09:23:/' file

Collectives™ on Stack Overflow

Perl Delete multiple lines from csv file beginning with specific string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related