Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to get output by awk
Top Forums Shell Programming and Scripting how to get output by awk Post 302106220 by vgersh99 on Wednesday 7th of February 2007 07:19:51 AM
Old 02-07-2007
Quote:
Originally Posted by milo
I found command by myself
nawk ' { if(length($2) == "2") { print $1, substr($3,1,1) } else { print $1, substr($2,3,2) } }' input > output

Is there better way?

Thanks,
Code:
nawk -F'[ ,)]' '{print $1, $(NF-1)}' input

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk output

could any one tell me why the following code is working in infinite loop every time it is asking for no. even though it does not have for loop #!/bin/awk -f BEGIN { print "type a number"; } { print "The square of ", $1, " is ", $1*$1; print "type another number"; } END { ... (3 Replies)
Discussion started by: useless79
3 Replies

2. Shell Programming and Scripting

Same awk gives different output:

nawk -F"|" '{for (i=1;i<=NF;i++) {gsub("^*", "",$i);gsub("*$", "",$i)}}1' OFS="|" file | wc -l 1000 nawk -F"|" '{for (i=1;i<=NF;i++) {gsub("^*", "",$i);gsub("*$", "",$i);print $0}}' OFS="|" file | wc -l 22000 The above awk command are same but with different printing... (1 Reply)
Discussion started by: pinnacle
1 Replies

3. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies

4. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of... (6 Replies)
Discussion started by: dagigg
6 Replies

5. Shell Programming and Scripting

awk: round output or delimit output of arithmatic string

I have a file with the following content. > cat /tmp/internetusage.txt 6709.296322 30000 2/7/2010 0.00I am using the following awk command to calculate a percentage from field 1 and 2 from the file. awk '{ print $1/$2*100 }' /tmp/internetusage.txt This outputs the value "22.3643" as a... (1 Reply)
Discussion started by: jelloir
1 Replies

6. Shell Programming and Scripting

help on awk---- need to assign the output of awk to a variable

hi i want to find the size of a folder and assign it to a variable and then compare if it is greater than 1 gb. i am doin this script, but it is throwing error.... #!/bin/ksh cd . | du -s | size = awk '{print $1}' if size >= 112000 then echo size high fi ERROR : (4 Replies)
Discussion started by: Nithz
4 Replies

7. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

Hi All, I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file. Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies

8. Shell Programming and Scripting

awk question : system output to awk variable.

Hi Experts, I am trying to get system output to capture inside awk , but not working: Please advise if this is possible : I am trying something like this but not working, the output is coming wrong: echo "" | awk '{d=system ("date") ; print "Current date is:" , d }' Thanks, (5 Replies)
Discussion started by: rveri
5 Replies

9. Shell Programming and Scripting

awk output

hello all input file AAA: XXX1 CCC: DD SS SSS: SSS1 BBBB: ASAS ZZZ: ZZZZZ1 XXX: XXXXXXXXXXXXXXX1 PPPP: PPPPPP1 RRRR: 111111111 ZZZ: ZZZZZ2 XXX: XXXXXXXXXXXXXXX2 PPPP: PPPPPP2 RRRR: 222222222 ZZZ: ZZZZZ3 XXX: XXXXXXXXXXXXXXX3 PPPP: PPPPPP3 RRRR: 33:33:33:33:33 (2 Replies)
Discussion started by: vikus
2 Replies

10. Shell Programming and Scripting

awk output yields error: awk:can't open job_name (Autosys)

Good evening, Im newbie at unix specially with awk From an scheduler program called Autosys i want to extract some data reading an inputfile that comprises jobs names, then formating the output to columns for example 1. This is the inputfile: $ more MapaRep.txt ds_extra_nikira_usuarios... (18 Replies)
Discussion started by: alexcol
18 Replies

LEARN ABOUT HPUX

show_link

show link(1m)															     show link(1m)

NAME

       show link - Displays attribute information about the specified soft link

SYNOPSIS

       cdscp show link link-name [attribute-name] [with attribute-name = attribute-value]

ARGUMENTS

       The  full  name	of  a  specific soft link.  The last simple name can contain wildcard characters.  The name of a particular attribute; see
       Description for valid attribute names.  The value of a particular attribute.

DESCRIPTION

       The show link command displays the names and values of the attributes specified in attribute-name.  You can use a combination of attributes
       in  any	sequence  in  a  single command. Use a space to separate multiple attributes.  You can use a with attribute-name = attribute-value
       clause to limit output only to soft links whose attributes have values equal to the specified values.  A space must precede and follow  the
       = (equals sign).  If you do not supply any attributes, the command displays all attributes and their values. The following is a description
       of soft link attributes: Specifies the creation timestamp (CTS) of this soft link Specifies the full name of the directory,  object  entry,
       or other soft link to which the soft link points Specifies a timeout value after which the soft link is either checked or deleted Specifies
       the timestamp of the most recent update to an attribute of the soft link

   Privilege Required
       You must have read permission to the soft link.	If you specify a wildcard soft link name, you also need read permission to  the  directory
       that stores the soft link.

NOTE

       This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.

EXAMPLE

       The  following command displays the current values of all the attributes associated with the soft link /.:/sales/region1.  cdscp> show link
       /.:/sales/region1

			       SHOW
			   SOFTLINK   /.../abc.com/sales/region1
				 AT   1991-10-15-15:54:40
			    CDS_CTS = 1991-10-15-19:54:35.00000003/08-00-2b-1c-8f-1f
			    CDS_UTS = 1991-10-15-19:54:35.00000006/08-00-2b-1c-8f-1f
		     CDS_LinkTarget = /.../abc.com/sales/service

			       SHOW
			   SOFTLINK   /.../abc.com/sales/region1
				 AT   1991-10-15-15:54:41
			    CDS_CTS = 1991-10-15-19:54:36.00000077/08-00-2b-1c-8f-1f
			    CDS_UTS = 1991-10-15-19:54:36.00000009/08-00-2b-1c-8f-1f
		     CDS_LinkTarget = /.../abc.com/sales/software
		    CDS_LinkTimeout = :
			 Expiration = 1991-10-15-00:00:00.0
			  Extension = +1-00:00:00.000

RELATED INFORMATION

       Commands: create link(1m), delete link(1m), list link(1m), remove link(1m), set link(1m)

																     show link(1m)
All times are GMT -4. The time now is 08:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy