How to delete row in csv file on date range?

UNIX for Beginners Q & A
1

I want to delete row in csv file , which row value from 2009-10-01 to 2011-06-03 using script.my csv row data look like:

2009-10-01
2011-03-30 
                  2011-03-31
2011-04-01 
                  2011-06-03
2011-06-30 
                  2011-07-01 
                  2011-09-28                   
2011-09-29
2

Welcome to the forum.

Please make sure to comply to our rules, esp. posting in an adequate forum, and using (CODE) tags.

After having added the tags, it can be seen that the data belong to different fields (= columns) separated by spaces. It's usually best to post comprehensive, representative samples along with OS and shell versions and preferred tools - if any.

3

How far would

awk -vDTMN="2009-10-01" -vDTMX="2011-06-03" '
BEGIN                   {gsub (/-/, _, DTMN)
                         gsub (/-/, _, DTMX)
                        }
                        {T = $1
                         gsub (/-/, _, T)
                        }
T < DTMN || T > DTMX
' file
2011-06-30
2011-07-01
2011-09-28
2011-09-29

get you?

4

Dear RudiC, It works fine but i have too many date rows like 1048576 rows.In this case it's not working when i save file to the new file it remains same.

5

Difficult to believe. Post data / samples.

6

@RudiC ,here is my data file

7

Works perfectly for me. Where exactly is your problem?

8

Thanks:) RudiC.It work's fine.it's my fault to see the row values.