Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with awk statement
Top Forums Shell Programming and Scripting Help with awk statement Post 302842481 by bombcan on Friday 9th of August 2013 10:55:22 AM
Old 08-09-2013
Help with awk statement
Hi

I have a file with

Code:
test test2 1000000657373
test1 test3 1000003849450
test2 test4 test5 100000837474

I cat the file and pipe it to an awk statement like so

Code:
cat /tmp/file |awk '{if ($3 ~ "^[0-9][0-9]*$" && $3 > 1024000000) print "/vol/"$1"/"$2;else if ($4 ~ "^[0-9][0-9]*$" && $4 > 1024000000) print "/vol/"$1"/"$2 " "$3}'

Which the output is

Code:
/vol/test/test2
/vol/test1/test3
/vol/test2/test4 test5

How can I get it to print something at the begining and in between to look like
Code:
INSERT
/vol/test/test2
INSERT
/vol/test1/test3
INSERT
/vol/test2/test4 test5

Thanks and much appreciated
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

if statement in awk

Hi Friends How do I do two things from one if statement inside awk? I want to run a script and create a new file from the same condition. awk '{ if ($2 == ""){print " "|"cd /local/test; ./script.ksh"}{cat > ran_true.txt}}' $IN_FILE Bolded are the two things I want to be done. Thanks (1 Reply)
Discussion started by: UNovIX
1 Replies

2. Shell Programming and Scripting

awk inside another awk statement

hi all, i have two files 1) a.txt one two three 2) abc "one" = 10 pqr "three" = 20 345 "two" = 0 this is what i want in third file (3 Replies)
Discussion started by: shishirkotkar
3 Replies

3. Shell Programming and Scripting

awk, if statement

Having a little trouble with awk and an if statement. I have a test setup which I am trying to only print the records which start with the month 03. Everything I tried, prints everything, even the 02 month 03/23/2010 12:47:51 ga2828 SUBMITTED FROM URL: test123.cgi show port count ... (2 Replies)
Discussion started by: numele
2 Replies

4. Shell Programming and Scripting

Awk 'if' statement help

Hello all, I'm very new to this (<5hrs!) please bear with me. My file looks like this 386259.448541 417069.155 154935.157 186.206 162 1 1 8 386259.448551 417068.53 154935.04 186.144 156 1 1 8 386259.448561 417067.911 154934.926 186.175 164 1 1 8 386259.450337 417086.643 154946.483 894.671... (4 Replies)
Discussion started by: rebeccab37
4 Replies

5. Shell Programming and Scripting

Help Regarding AWk and IF THEN ELSE Statement

Hi, I have a data file which contains record count. So doing wc -l rightfit_balancing_count.dat | awk '{print $1}'] gives me the record count stored in the file. Now, i want to send a mail from UNIX, if the record count is equal to 0,otherwise it should do nothing. Any help... (2 Replies)
Discussion started by: Shell_Learner
2 Replies

6. Shell Programming and Scripting

awk if statement

hi, I have a l-column file of more than 10,000 lines with interspersed negative values. What I want to do is add a fixed number (360) everytime a negative value is encountered while leaving the positive ones as is. I need something that will read every line of the file and do the calculation... (3 Replies)
Discussion started by: ida1215
3 Replies

7. Shell Programming and Scripting

If statement in awk

I run my script "switch.sh" repeatedly (within 30 seconds). Each time script is triggered, script itself should kill all previous process. Here is my code: for pid in $(ps -fe | grep 'switch.sh' | grep -v grep | awk '{if ($2<$$) print $2}'); do sudo kill -9 $pid done sleep 30 ... (6 Replies)
Discussion started by: armatron
6 Replies

8. Shell Programming and Scripting

awk if then else statement

I am using awk as part of and if then else statement. I am trying to have the user enter a gene name and then a variant or variants and have a specific transcript assigned to the variants depending on the gene. Below is my code but the if then else statement is wrong. Basically, the gene name... (2 Replies)
Discussion started by: cmccabe
2 Replies

9. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies

10. Shell Programming and Scripting

awk statement help

There has to be a way to do this with awk or maybe I'm just focusing on the wrong tool and making this harder than it needs to be. I'm trying to do a file field lookup/join at a very large scale but the output changes has to change dramatically. I have an input file to do a field lookup from and... (3 Replies)
Discussion started by: brettcasper
3 Replies

LEARN ABOUT DEBIAN

clmvol

clm vol(1)							  USER COMMANDS 							clm vol(1)

  NAME
      clm vol - compute volatile nodes from a set of clusterings

      clmvol  is  not  in actual fact a program. This manual page documents the behaviour and options of the clm program when invoked in mode vol.
      The options -h, --apropos, --version, -set, --nop are accessible in all clm modes. They are described in the clm manual page.

  SYNOPSIS
      clm vol [-fraction num (nff factor)] [-o fname (output file)] <cl file>+

  DESCRIPTION
      clm vol computes a score for each node, which at a minimum is equal to one.  The output is in the form of a matrix containing a single  col-
      umn.  The  score	correlates with what is deemed to be volatile behaviour. For all pairs of clusterings the set of all intersections is com-
      puted, and these are considered in turn.	An intersection is deemed to be volatile if the size of the intersection is  less  than  half  the
      size  of	the  smallest of the two clusters. In that case, for each node in the intersection its volatility score is incremented by one over
      the size of the intersection.  The size comparison can be made more stringent by increasing the -fraction <frac> option, which is by default
      set  to 0.5.  Volatility occurs if the size of the intersection is less than <frac> times the size of the smallest cluster. If the -fraction
      value is increased all the way up to 1.0, the implication is that an intersection is considered volatile unless one  of  the  two  clusteres
      considered is a subset of the other.

  AUTHOR
      Stijn van Dongen.

  OPTIONS
      -fraction num (nff factor)
	See the discussion at DESCRIPTION.

      -o fname (output file)

  SEE ALSO
      mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.

  clm vol 12-068						      8 Mar 2012							  clm vol(1)
All times are GMT -4. The time now is 03:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy