Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK to separate numbers from logs
Top Forums Shell Programming and Scripting AWK to separate numbers from logs Post 302349764 by EAGL€ on Tuesday 1st of September 2009 06:28:54 PM
Old 09-01-2009
Franklin you are great,thank you very much indeed for reminding me of /usr/xpg4/bin/awk ;when i run your and Klassh's command they both worked:

Code:
/usr/xpg4/bin/awk '/[Ee]stimated/ {gsub(/\(|\..*/,"",$5);print $5}' mylog.txt
/usr/xpg4/bin/awk '/[Ee]stimated/ {sub("\(","",$5);print int($5)}' mylog.txt
both gave  1515  thats what exactly i want.

you know always using normal awk (not from xpg4/bin ) you get used to it and when you face an error it just makes you think as if it is caused by bad code and misleads you.This reminds me of ggrep case, it only works from under /usr/sfw/bin/ that is forgettable (if you dont put it env path).

regards
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to separate numbers and words from a file using shell scripts

Hi, How to separate numbers and words(with full alphabets) in a particular file and store it in two different files. Please help me out for this.Using shell scripting. :confused::confused: (1 Reply)
Discussion started by: kamakshi s
1 Replies

2. Shell Programming and Scripting

awk command to separate a field

I have a log file that I am trying to convert. File contents something like this: aaaaa bbbbbb cccc dddddd\123 eeeee ffffffff I am trying to output the fields in a different order and separate field 4 so that the "123" and "dddddd" can be output separately. for example bbbbbb aaaaa 123... (5 Replies)
Discussion started by: jake1988
5 Replies

3. Shell Programming and Scripting

separate numbers in a file

I have this command in a shl (UNIX) to find the lates file that start with EMT in a directory file=$(ls -tr $EMT*.dat | tail -1) # Select the latest file It finds: EMT345.dat then I have to be able to separate EMT AND the numbers 345 and stored 345 in a variable and incremented, so my new... (7 Replies)
Discussion started by: rechever
7 Replies

4. Shell Programming and Scripting

separate two numbers separated by :

Hi all i have a data of this form 10.12.4.22:138 10.12.2.50:137 10.20.2.24:1027 10.12.2.44:138 10.12.2.44:137 10.0.4.38:58871 10.13.3.19:138 i need to separate the number out which is at the last and after ':' Please help me out Thanx in advance (5 Replies)
Discussion started by: vaibhavkorde
5 Replies

5. Shell Programming and Scripting

Awk variable in a separate file

Hi all, I have a requirement to put all the varibles used in an awk command in a separate file. This is because i have arround 100 variables used in an awk command. So i want to put all the variables used for the awk command in a separate file. Please help me on this. Thanks in adv. (6 Replies)
Discussion started by: gani_85
6 Replies

6. Shell Programming and Scripting

Separate two numbers

I would like to separate number by space so that 121231212 222111212 would be 1 2 1 2 3 1 2 1 2 2 2 2 1 1 1 2 1 2 Thanks! (2 Replies)
Discussion started by: johnkim0806
2 Replies

7. Shell Programming and Scripting

Help awk/sed: putting a space after numbers:to separate number and characters.

Hi Experts, How to sepearate the list digit with letters : with a space from where the letters begins, or other words from where the digits ended. file 52087mo(enbatl) 52049mo(enbatl) 52085mo(enbatl) 25051mo(enbatl) The output should be looks like: 52087 mo(enbatl) 52049... (10 Replies)
Discussion started by: rveri
10 Replies

8. Shell Programming and Scripting

Line numbers and exception to be caught in logs

Hi Folks, I have just basic queries is that suppose I have to monitor the logs then there is a command , suppose I have to monitor the abc.log which is updating dynamically within seconds so the command will be after going to that directory is .. tail -f abc.log Now please advise what about... (1 Reply)
Discussion started by: punpun66
1 Replies

9. Shell Programming and Scripting

Csv file separate using awk

Hi, I have file like below apple,orange,pineapple,pappya,guva,avocado want to store as apple orange pineapple pappya I tried below command to seprate first field command1: (3 Replies)
Discussion started by: stew
3 Replies

10. Shell Programming and Scripting

awk separate files to one directory

I am trying to output all files that are made by this awk to a specific directory. awk -F '' '{f = $3 ".txt"; print > f}' input.txt Since the actual data has several hundred files I redirect the output (well tried to) to a directory. awk -F '' '{f = $3 ".txt"; close($3 ".txt")} print >... (6 Replies)
Discussion started by: cmccabe
6 Replies

LEARN ABOUT OPENSOLARIS

basename

basename(1)							   User Commands						       basename(1)

NAME

       basename, dirname - deliver portions of path names

SYNOPSIS

       /usr/bin/basename string [suffix]

       /usr/xpg4/bin/basename string [suffix]

       dirname string

DESCRIPTION

       The  basename  utility deletes any prefix ending in / and the suffix (if present in string) from string, and prints the result on the stan-
       dard output. It is normally used inside substitution marks (``) within shell procedures.

   /usr/bin
       The suffix is a pattern defined on the expr(1) manual page.

   /usr/xpg4/bin
       The suffix is a string with no special significance attached to	any of the characters it contains.

       The dirname utility delivers all but the last level of the path name in string.

EXAMPLES

       Example 1 Setting environment variables

       The following example, invoked with the argument /home/sms/personal/mail sets the environment variable NAME to the file named mail and  the
       environment variable MYMAILPATH to the string  /home/sms/personal:

	 example% NAME=`basename $HOME/personal/mail`
	 example% MYMAILPATH=`dirname $HOME/personal/mail`

       Example 2 Compiling a file and moving the output

       This  shell  procedure,	invoked  with  the argument /usr/src/bin/cat.c, compiles the named file and moves the output to cat in the current
       directory:

	 example% cc $1
	 example% mv a.out `basename $1 .c`

ENVIRONMENT VARIABLES

       See environ(5) for descriptions of the following environment variables that affect  the execution of basename and  dirname:  LANG,  LC_ALL,
       LC_CTYPE, LC_MESSAGES, and NLSPATH.

EXIT STATUS

       The following exit values are returned:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

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

   /usr/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

   /usr/xpg4/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWxcu4			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       expr(1), basename(3C), attributes(5), environ(5), standards(5)

SunOS 5.11							    18 Mar 1997 						       basename(1)
All times are GMT -4. The time now is 12:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy