Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parsing log with sed problem
Top Forums Shell Programming and Scripting Parsing log with sed problem Post 302485651 by Chubler_XL on Wednesday 5th of January 2011 09:43:05 PM
Old 01-05-2011
How about this:

Code:
#!/bin/sh
sed -n \
    -e '/\-\-SELECT/  s/^.*\-\-//p' \         
    -e '/\-\-UPDATE/  s/^.*\-\-//p' \        
    -e '/\-\-DELETE/  s/^.*\-\-//p' \        
    -e '/#STMT#/      s/\].*//'     \
    -e '/#STMT#/      s/.*# \[//p' $1

-- Edit --
or, I think this is the sort of thing DGPickett was suggesting:
Code:
#!/bin/sh
sed -n \
    -e '/\-\-begin/d' \
    -e '/\-\-commit/d' \
    -e 's/^.*])\-\-//p' \
    -e '/#STMT#/s/^.*# \[\([^]]*\)].*/\1/p'

Last edited by Chubler_XL; 01-05-2011 at 11:04 PM..
These 2 Users Gave Thanks to Chubler_XL For This Post:
DerekAsirvadem migurus
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed parsing

hi , i would like to parse some file with the fallowing data : data data data "unwanted data" data data "unwanted data" data data data data #unwanted data. what i want it to have any coments between "" and after # to be erased using awk or/and sed. has anyone an idea? thanks. (3 Replies)
Discussion started by: Darsh
3 Replies

2. Shell Programming and Scripting

Sed parsing error

I'm having a problem with a sed script. A programmer needs to change columns 942,943,944 to blank spaces only where it has the number 999 in every line. I didn't have a copy of the data file to test with originally so made my own up with a bunch of x's and put 999 in columns 5-7. The sed... (1 Reply)
Discussion started by: gravy26
1 Replies

3. Shell Programming and Scripting

Another parsing line awk or sed problem

Hi, After looking on different forums, I'm still in trouble to parse a parameters line received in KSH. $* is equal to "/AAA:111 /BBB:222 /CCC:333 /DDD:444" I would like to parse it and be able to access anyone from his name in my KSH after. like echo myArray => display 111 ... (1 Reply)
Discussion started by: RickTrader
1 Replies

4. Shell Programming and Scripting

Parsing with awk or sed

I want to delete corrupt records from a file through awk or sed. Can anyone help me with this Thanks Striker Change subject to a descriptive one, ty. (1 Reply)
Discussion started by: Rahul_us
1 Replies

5. Shell Programming and Scripting

Parsing cron with sed

Hello I want to convert my cron list into a csv Can you please help me with sed ? eg: Convert #06,21,36,51 * * 1,2 * (. ~/.profile ; timex /some/path/script -30 -15) >> /some/path/logfile2 2>&1 * * * * * (. ~/.profile ; timex /some/path/script2) > /some/path/logfile2 To:... (1 Reply)
Discussion started by: drbiloukos
1 Replies

6. Shell Programming and Scripting

sed (parsing value)

All, Can somebody provide me with some sed expertise on how to parse the following line. 27-MAR-2011 10:28:01 * (CONNECT_DATA=(SID=dmart)(CID=(PROGRAM=sqlplus)(HOST=mtasnprod1)(USER=mtasnord))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.197.7.47)(PORT=54881)) * establish * dmart * 0 I would like... (3 Replies)
Discussion started by: BeefStu
3 Replies

7. Shell Programming and Scripting

Sed special parsing

What is the shortest & right way to remove the string "" with a sed statement ? echo 'whateverwhatever' | sed ........ ? :) (2 Replies)
Discussion started by: ctsgnb
2 Replies

8. Shell Programming and Scripting

[SED] Parsing to get a single value

Hello guys, I guess you are fed up with sed command and parse questions, but after a while researching the forum, I could not get an answer to my doubt. I know it must be easy done with sed command, but unfortunately, I never get right syntax of this command OK, this is what I have in my... (3 Replies)
Discussion started by: manolain
3 Replies

9. UNIX for Dummies Questions & Answers

sed or Grep Parsing

I would like to parse two strings from lines in a file only when both strings appear on the same line. For example, if I have the following line: string1 string2 string3 string4 string5 string6 string7 string8 string9 I would like the output to be: string2: string7 Can someone give me... (5 Replies)
Discussion started by: ARBlue79
5 Replies

10. Shell Programming and Scripting

Parsing via sed issue

sorry I messed up the last post with too many mistakes and corrections so I closed it and opening a new one which should be clear to everyone .my apologies to the admins. I am using sun solaris and Linux , what I want is SED to print any string (or output it to a file preferably) that does... (2 Replies)
Discussion started by: boncuk
2 Replies

LEARN ABOUT PLAN9

pkgproto

pkgproto(1)							   User Commands						       pkgproto(1)

NAME

       pkgproto - generate prototype file entries for input to pkgmk command

SYNOPSIS

       pkgproto [-i] [-c class] [path1]

       pkgproto [-i] [-c class] [path1=path2...]

DESCRIPTION

       pkgproto scans the indicated paths and generates prototype(4) file entries that may be used as input to the pkgmk(1) command.

       If  no paths are specified on the command line, standard input is assumed to be a list of paths. If the pathname listed on the command line
       is a directory,	the contents of the directory is searched.  However, if input is read from stdin, a directory specified as a pathname will
       not be searched.

OPTIONS

       -i	       Ignores symbolic links and records the paths as ftype=f (a file) versus ftype=s (symbolic link).

       -c class        Maps the class of all paths to class.

OPERANDS

       path1	Pathname where objects are located.

       path2	Pathname which should be substituted on output for path1.

EXAMPLES

       Example 1: Examples of the use of pkgproto.1.

       The following two examples show uses of pkgproto and a partial listing of the output produced.

       Example 1:

       example% pkgproto /bin=bin /usr/bin=usrbin /etc=etc
       f none bin/sed=/bin/sed 0775 bin bin
       f none bin/sh=/bin/sh 0755 bin daemon
       f none bin/sort=/bin/sort 0755 bin bin
       f none usrbin/sdb=/usr/bin/sdb 0775 bin bin
       f none usrbin/shl=/usr/bin/shl 4755 bin bin
       d none etc/master.d 0755 root daemon
       f none etc/master.d/kernel=/etc/master.d/kernel 0644 root daemon
       f none etc/rc=/etc/rc 0744 root daemon

       Example 2:

       example% find / -type d -print | pkgproto
       d none / 755 root root
       d none /bin 755 bin bin
       d none /usr 755 root root
       d none /usr/bin 775 bin bin
       d none /etc 755 root root
       d none /tmp 777 root root

EXIT STATUS

       0	Successful completion.

       >0	An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       pkgmk(1), pkgparam(1), pkgtrans(1), prototype(4), attributes(5)

       Application Packaging Developer's Guide

NOTES

       By  default,  pkgproto creates symbolic link entries for any symbolic link encountered (ftype=s). When you use the -i option, pkgproto cre-
       ates a file entry for symbolic links (ftype=f). The prototype(4) file would have to be edited to assign such file types as v (volatile),  e
       (editable), or x (exclusive directory). pkgproto detects linked files. If multiple files are linked together, the first path encountered is
       considered the source of the link.

       By default, pkgproto prints prototype entries on the standard output. However, the output should be saved in a  file  (named  Prototype	or
       prototype, for convenience) to be used as input to the pkgmk(1) command.

SunOS 5.10							    6 Nov 2000							       pkgproto(1)
All times are GMT -4. The time now is 09:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy