Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Manipulating xyz file with awk-if-else or sed
Top Forums Shell Programming and Scripting Manipulating xyz file with awk-if-else or sed Post 302669957 by Corona688 on Wednesday 11th of July 2012 12:48:18 PM
Old 07-11-2012
You don't need if-else for this. The 'ignore' happens by default anyway, you don't need a case for that.

You can put a condition in front of a code block which will cause it to be executed only when it's true, sort of like an if. Also, you can do math on columns directly.

Code:
awk '($3+0) < 0 { $3 += 20 } 1' filename

The ($3+0) is just to turn the third column, $3, from a string into a number so < > = will work on it as expected.
Last edited by Corona688; 07-11-2012 at 01:59 PM..
This User Gave Thanks to Corona688 For This Post:
Vryali
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How would you replace the n character in a file with some xyz?

How would you replace the n character in a file with some xyz? (2 Replies)
Discussion started by: JosephGerard
2 Replies

2. Shell Programming and Scripting

Manipulating awk $variables using sed?

I have been searching around the forums here trying to find a solution to my problem but not getting anywhere but closer to baldness. I have a 20 column pipe "|" seperated text file. The 14th variable doesnt always exist, but will have the format of YYYYMM or YYYY if it does. I need to take... (2 Replies)
Discussion started by: r0sc0
2 Replies

3. UNIX for Dummies Questions & Answers

Help!! manipulating file

Hi all, I need help manipulating the file below. Here is what I needed to do. First, I have to replace INSUPD to DELETE. Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD") How should I attack this? Here... (2 Replies)
Discussion started by: sirrtuan
2 Replies

4. Shell Programming and Scripting

manipulating Fields in file using SED

Hi, I have two issues: I have one file say file1.dat and its over 3GB. It contains pipe delimited fields. The first line in the file is the header field which tells the column names etc. and from second line it's the data fileds with pipe delimited. Something like below: ... (5 Replies)
Discussion started by: rkumar28
5 Replies

5. Shell Programming and Scripting

Manipulating Pick multi dimensional data with awk.

Hi. I am reasonably new to awk, but have done quite a lot of unix scripting in the past. I have resolved the issues below with unix scripting but it runs like a dog. Moved to awk for speed and functionality but running up a big learning curve in a hurry, so hope there is some help here. I... (6 Replies)
Discussion started by: mike.strategis
6 Replies

6. Shell Programming and Scripting

Manipulating the etc/passwd file with sed

How can i use sed to extract the user name and home directory from the /etc/passwd/ file on my server. (11 Replies)
Discussion started by: Pauline mugisha
11 Replies

7. Shell Programming and Scripting

Manipulating a header file using awk or sed

Hi Guys, Is there a simple way of doing the below. Available<spaces>Assigned<spaces>Maximum<spaces>Maximum<spaces>Page<spaces>Total <spaces>Used<spaces>Pct<spaces>Max. Pct<CR> Space<spaces>Capacity<spaces>Extension<spaces>Reduction<spaces>Size<spaces>... (8 Replies)
Discussion started by: eo29
8 Replies

8. Shell Programming and Scripting

awk xyz file in a for loop

hi good day I have a number of text files (xyz) that I want to format in to defined column widths (that is 7 digits (padding with zeros in cases where necessary) with 6 decimal places) using awk. . I can perform this on one text file at a time without any problems. However I want to write a... (2 Replies)
Discussion started by: johnstrong
2 Replies

9. Shell Programming and Scripting

Manipulating a variable using sed (solved)

Hi, My variable has value as this: tvar1="bool_risk_enabled" Boolean "true" Now I need to replace this true with false. Which is the best way to do this? Can we do this with sed command? Please help me. ---------- Post updated at 05:23 PM ---------- Previous update was at 05:00 PM... (2 Replies)
Discussion started by: pravintse
2 Replies

10. Shell Programming and Scripting

Manipulating xml data with awk

Hi everyone, I have a little bit of complicated task to finish with AWK. Here it is; I have a data file in xml format which looks like this <data> a1 a2 a3 a4 a5 b1 b2 b3 b4 b5 c1 c2 c3 c4 c5 d1 d2 d3 d4 d5 e1 e2 e3 e4 e5 </data> lets say each data block contains 5 rows and 5 columns,... (13 Replies)
Discussion started by: hayreter
13 Replies

LEARN ABOUT OSX

roman

math::roman(1.0)														  math::roman(1.0)

__________________________________________________________________________________________________________________________________________________

NAME

       math::roman - Tools for creating and manipulating roman numerals

SYNOPSIS

       package require Tcl  8.3

       package require math::roman  ?1.0?

       ::math::roman::toroman i

       ::math::roman::tointeger r

       ::math::roman::sort list

       ::math::roman::expr args

_________________________________________________________________

DESCRIPTION

       ::math::roman  is a pure-Tcl library for converting between integers and roman numerals. It also provides utility functions for sorting and
       performing arithmetic on roman numerals.

       This code was originally harvested from the Tcler's wiki at http://wiki.tcl.tk/1823 and as such is free for any use for any  purpose.  Many
       thanks to the ingeneous folk who devised these clever routines and generously contributed them to the Tcl community.

       While written and tested under Tcl 8.3, I expect this library will work under all 8.x versions of Tcl.

COMMANDS

       ::math::roman::toroman i
	      Convert an integer to roman numerals. The result is always in upper case. The value zero is converted to an empty string.

       ::math::roman::tointeger r
	      Convert a roman numeral into an integer.

       ::math::roman::sort list
	      Sort a list of roman numerals from smallest to largest.

       ::math::roman::expr args
	      Evaluate an expression where the operands are all roman numerals.

       Of these commands both toroman and tointeger are exported for easier use. The other two are not, as they could interfer or be confused with
       existing Tcl commands.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category math	::
       roman  of  the  Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may
       have for either package and/or documentation.

KEYWORDS

       conversion, integer, roman numeral

CATEGORY

       Mathematics

COPYRIGHT

       Copyright (c) 2005 Kenneth Green <kenneth.green@gmail.com>

Tcl Math Library						       math							  math::roman(1.0)
All times are GMT -4. The time now is 09:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy