Parsing dates

[segment]

Hey all, I would have tried to do this in sed but the file is a bit large...

I have a CSV file (Asterisk) and I need to parse out a range of dates from it...

"","8605551212","1223","outbound","""RECEPTION"" <8605551212>","SIP/1201-08f42e80","SIP/1223-08e75548","Dial","SIP/1223|25|tr","2006-07-27 13:03:49",,"2006-07-27 13:04:10",21,0,"NO ANSWER","DOCUMENTATION"


"","8605551212","1223","outbound","""RECEPTION"" <8605551212>","SIP/1201-08f42e80","SIP/1223-08e75548","Dial","SIP/1223|25|tr","2006-07-27 13:03:49",,"2006-08-06 13:04:10",21,0,"NO ANSWER","DOCUMENTATION"

Normally I would first view the file (more filename) then get to a specific date, get a line count then wc -l it and print out those lines in sed...

sed -n '$LINE__NUMBER_BEGIN,LINE_NUMBER_ENDp' filename >> parsed

But I'm sure an awkpimp has a better solution....

 

[feherke]

Hi

That [tt]sed[/tt] oneliner's [tt]awk[/tt] equivalent is

awk '{NR>=LINE__NUMBER_BEGIN && NR<=LINE_NUMBER_END}' filename >> parsed

But for your date question seems to need

awk '{gsub(/"/,"",$10)} $10>="[green][i]stardate[/i][/green]" && $10<="[green][i]enddate[/i][/green]"' filename

Feherke.

http://rootshell.be/~feherke/

 

[segment]

Thanks... Didn't seem to work though. I think I'm going to bite the bullet, open up the 6 files and do it manually

 

[feherke]

Hi

Sorry, I copy&pasted wrong code. Should be :

awk [red]-F,[/red] '{gsub(/"/,"",$10)} $10>="[green][i]stardate[/i][/green]" && $10<="[green][i]enddate[/i][/green]"' filename

Feherke.

http://rootshell.be/~feherke/

 

[segment]

Thanks feherke... You should start a write up on AWK and handy onliners and throw it on your page

 

[feherke]

Hi

You are too kind, segment. But when I see PHV's shorter, better, faster solutions I am not so sure that I am the right person to do that. I could stil learn a lot from other people's one-liner collections... if I have time.

Feherke.

http://rootshell.be/~feherke/

 

[segment]

Perhaps you and PHV should get together and write something like an O'Reilly book. Not kidding you or trying to inflate egos here.