SED help, small problem

06-11-2010

Registered User

16, 0

Join Date: Oct 2002

Last Activity: 15 November 2011, 4:30 AM EST

Posts: 16

Thanks Given: 5

Thanked 0 Times in 0 Posts

SED help, small problem

Hi,

I have this sed command to grep a date from a filename for a script we have.
I am awful with sed so I need help.
Sometimes it works fine but other times it does not, see below.

works

Code:

bash-3.00# echo /US/fwadmnyc05-ezone.us.db.com/nj34ex08k3y07/http_log.nj34ex08k3y07.2010.06.04.00.05.00.432.gz | sed -e 's#.*/##' -e 's#[^0-9][^0-9]*[.]\([0-9][0-9.][0-9.]*\)[.].*#\1#'
http_log.nj34ex08k3y07.2010.06.04.00.05.00.432.gz

Doesn't work, the 2009 is part of the filename:

Code:

bash-3.00# echo /US/fwadmnyc05-ezone.us.db.com/nj02ga03e2y39a/http_log.nj02ga03e2y39a.2009.11.16.01.01.03.274.gz|sed -e 's#.*/##' -e 's#[^0-9][^0-9]*[.]\([0-9][0-9.][0-9.]*\)[.].*#\1#' 
http_log.nj02ga03e2y392009.11.16.01.01.03.274

by the way there is obviously another | cut -d. -f3,4,5 after the above commands to just get the dates but the sed seems to be the issue.
I really do not understand why it sometimes work or sometimes does not as the filename format is the same...

The file format is always http_log.hostname.yyyy.mm.dd.some.info.blah.gz

Help please

Last edited by GermanJulian; 06-11-2010 at 10:36 AM.. Reason: to fix something

GermanJulian

View Public Profile for GermanJulian

Find all posts by GermanJulian

06-11-2010

Registered User

6,575, 572

Join Date: Sep 2007

Last Activity: 5 November 2019, 9:08 AM EST

Location: St. Gallen, Switzerland

Posts: 6,575

Thanks Given: 179

Thanked 572 Times in 484 Posts

If it's ok without sed, shell can do it too:

Code:

$> VAR='/US/fwadmnyc05-ezone.us.db.com/nj02ga03e2y39a/http_log.nj02ga03e2y39a.2009.11.16.01.01.03.274.gz'
$> echo ${VAR##*/}
$> http_log.nj02ga03e2y39a.2009.11.16.01.01.03.274.gz

With sed I would write it like this (back referencing):

Code:

sed 's#.*/\([^/]*\)#\1#g'

This User Gave Thanks to zaxxon For This Post:

zaxxon

View Public Profile for zaxxon

Find all posts by zaxxon

Shell Programming and Scripting

SED help, small problem

10 More Discussions You Might Find Interesting

1. Linux

Small problem

Discussion started by: suppliernr1

2. Shell Programming and Scripting

sed parse small xml file

Discussion started by: unclecameron

3. Shell Programming and Scripting

small sed script on command line.

Discussion started by: lavascript

4. UNIX for Dummies Questions & Answers

A small AWK problem

Discussion started by: ChicagoBlues

5. UNIX for Dummies Questions & Answers

small problem

Discussion started by: yosef_yaniv

6. SCO

Small Problem with SCO

Discussion started by: rabih_saleh

7. IP Networking

Small problem...

Discussion started by: Green_Monkey23

8. Shell Programming and Scripting

Small Help on SED

Discussion started by: Chanakya.m

9. Shell Programming and Scripting

Small UNIX problem

Discussion started by: nbvcxzdz

10. Programming

a small problem

Discussion started by: mile1982