regex with sed to process file, need help on regex

dwynter · 08-30-2007, 11:01 AM

Hi,

I have a large log file. In it I have several sections delineated by a header and footer line. I want to process all line between each header footer pair to strip out just the end of the line and create a new file , one for each header footer pair.

Example

blah blah creating lock file XYZ.v
blah blah no identifier found for value = 345.O
random content line
blah blah no identifier found for value = 123.O
blah blah deleting lock file XYZ.v
random content line
random content line
blah blah creating lock file ABC.v
blah blah no identifier found for value = ABC.O
random content line
blah blah no identifier found for value = DEF.O
blah blah deleting lock file ABC.v

Where "blah blah " can be any text, "random content line" is any text on a line without the pattern to be ignored, "no identifier found for value = " is the thing to use to recognize a line.

"creating lock file " is used to recognise a start of a section as a header and the text to the right of this is used as the filename for the output. The output is anything to the right of the "no identifier found for value = " to the end of the line, each output without line break and wrapped in '<text found goes here>'. Then "deleting lock file " shows the end of that output as footer. like so:

'345.O','123.O' would go into a file called XYZ.v.txt

I can use sed -e for each line using >> to output all in a for loop using cat to list the contents of the file to sed, I think, but putting it all together is rather daunting. Also the regex is beyond me. Any experts who do this in their sleep?

Thanks,

David

dwynter · 08-30-2007, 11:33 AM

Here is what I think the script should look like in theory

for i in (cat /var/myapp/logfile)
do
$arg1 = sed -e '<header regex>'
$arg2 = sed -e '<footer regex>'
$arg3 = sed -e '<header regex>'
if [ $arg1 != "" ]
cat > $arg1
fi
if [ $arg2 != "" ]
^D > $arg1
fi
if [ $arg1 != "" ]
"'$arg3',"
fi
arg1=""
arg2=""
arg3=""
done

But of course it does not work the cat cat /var/myapp/logfile does not output a line at a time. Also not sure how to output a ^D to close the file.

dwynter · 08-30-2007, 11:35 AM

With code tags this time, dooh.

Code:

for i in (cat /var/myapp/logfile)
    do
        $arg1 = sed -e '<header regex>'
        $arg2 = sed -e '<footer regex>'
        $arg3 = sed -e '<header regex>'
        if [ $arg1 != "" ]
            cat > $arg1
        fi
        if [ $arg2 != "" ]
            ^D > $arg1
        fi
        if [ $arg1 != "" ]
            "'$arg3',"
        fi
        arg1=""
        arg2=""
        arg3=""
done

theYinYeti · 08-30-2007, 11:50 AM

I'd put something like this in a script file:

Code:

#!/bin/bash

sed -n '
  s/^.*creating lock file \(.*\)$/FILE \1/p
  t file
  d
  : file
  n
  /deleting lock file/ d
  s/^.*no identifier found for value = \(.*\)$/= \1/p
  b file
' | awk '
  function new() {
    if (content != "" && out != "") { print content >out; close(out); }
    out=$2 ".txt"
    content=""
  }
  $1=="FILE" { new(); }
  $1=="=" {
    if (content != "") content=content ","
    content=content "'"'"'" substr($0, 3) "'"'"'"
  }
  END { new(); }
'

You run this with ./script.sh <logfile

Yves.

dwynter · 08-31-2007, 05:23 AM

Hi,

I'd like to learn how this thing works, at all steps.

I understand the sed part processing the stream and outputting the required substrings. But this part I cannot find how this works in the sed tutorial

Code:

  t file
  d
  : file
  n
...
  b file

The other part that I think will not work is this

Code:

    content=content "'"'"'" substr($0, 3) "'"'"'"

Because the argument $0 is everything from the "no identifier found for value = " to the end of the line and that is variable length.

I did run it and got no output at all so something is not right.

If I run it in my home dir can I use a fullpath to the log file? Like so
./script.sh </var/myapp/logslogfile

Thx.

David

theYinYeti · 08-31-2007, 06:10 AM

Yes, that's it, and there is indeed no output, as everything is put into files with extension ".txt".
Here's what it does:

Code:

sed -n '
    | FOR EACH LOG LINE...
        | Output "FILE <name of file>" if it is a file name
  s/^.*creating lock file \(.*\)$/FILE \1/p
        | If it was indeed so (t), then branch to label "file"
  t file
        | Else delete line and start at beginning with next
  d
        | From this label on, we know we've found a file name
  : file
        | Read next line
  n
        | Until we fine the closing of the block
  /deleting lock file/ d
        | Meanwhile output all not-found values: "= <value>"
  s/^.*no identifier found for value = \(.*\)$/= \1/p
        | And so on...
  b file
        | Now, all this output is worked on with awk:
' | awk '
        | This function creates a new <name of file>.txt and reinit variables
  function new() {
                | Create file only if there is content
    if (content != "" && out != "") { print content >out; close(out); }
                | Then empty variables
    out=$2 ".txt"
    content=""
  }
    | FOR EACH LINE FROM SED...
        | If it is a file name, call the function
  $1=="FILE" { new(); }
        | Else append the unfound value to the content
  $1=="=" {
    if (content != "") content=content ","
    content=content "'"'"'" substr($0, 3) "'"'"'"
  }
        | At the end, we don't forget to create the last file
  END { new(); }
'

The "'"'"'" you see above is
" begin awk string (enclosed between ")
' close awk script (enclosed between ')
" begin bash string (enclosed between ")
' this string's content is a single quote (the actual content of the awk string)
" close bash string (enclosed between ")
' reopen awk script (enclosed between ')
" close awk string (enclosed between ")
All that is so that we can put a single quote inside the awk script without having to enclose the script within double quotes instead of single quotes, which would force us to escape ("\" character) each and every ", \, or $ inside the script.

Yves.