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 without changing the order of the data. any idea how to implement this using awk? Many thanks in advance.
sample file looks like the ones below:
Code:
original values desired output
135 135
123 123
144 144
-179 181 (-179+360)
-164 196 (-164+360)
156 156
145 145
-164 196 (-164+360)
156 156
-176 184 (-176+360)
and so on ..
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)
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)
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)
Hi
I have a file with
test test2 1000000657373
test1 test3 1000003849450
test2 test4 test5 100000837474
I cat the file and pipe it to an awk statement like so
cat /tmp/file |awk '{if ($3 ~ "^*$" && $3 > 1024000000) print "/vol/"$1"/"$2;else if ($4 ~ "^*$" && $4 > 1024000000) print... (15 Replies)
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)
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)
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)
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 OSX
isgraph
ISGRAPH(3) BSD Library Functions Manual ISGRAPH(3)NAME
isgraph -- printing character test (space character exclusive)
LIBRARY
Standard C Library (libc, -lc)
SYNOPSIS
#include <ctype.h>
int
isgraph(int c);
DESCRIPTION
The isgraph() function tests for any printing character except space (' ') and other locale-specific space-like characters. The value of the
argument must be representable as an unsigned char or the value of EOF.
In the ASCII character set, this includes the following characters (preceded by their numeric values, in octal):
041 ``!'' 042 ``"'' 043 ``#'' 044 ``$'' 045 ``%''
046 ``&'' 047 ``''' 050 ``('' 051 ``)'' 052 ``*''
053 ``+'' 054 ``,'' 055 ``-'' 056 ``.'' 057 ``/''
060 ``0'' 061 ``1'' 062 ``2'' 063 ``3'' 064 ``4''
065 ``5'' 066 ``6'' 067 ``7'' 070 ``8'' 071 ``9''
072 ``:'' 073 ``;'' 074 ``<'' 075 ``='' 076 ``>''
077 ``?'' 100 ``@'' 101 ``A'' 102 ``B'' 103 ``C''
104 ``D'' 105 ``E'' 106 ``F'' 107 ``G'' 110 ``H''
111 ``I'' 112 ``J'' 113 ``K'' 114 ``L'' 115 ``M''
116 ``N'' 117 ``O'' 120 ``P'' 121 ``Q'' 122 ``R''
123 ``S'' 124 ``T'' 125 ``U'' 126 ``V'' 127 ``W''
130 ``X'' 131 ``Y'' 132 ``Z'' 133 ``['' 134 ``''
135 ``]'' 136 ``^'' 137 ``_'' 140 ```'' 141 ``a''
142 ``b'' 143 ``c'' 144 ``d'' 145 ``e'' 146 ``f''
147 ``g'' 150 ``h'' 151 ``i'' 152 ``j'' 153 ``k''
154 ``l'' 155 ``m'' 156 ``n'' 157 ``o'' 160 ``p''
161 ``q'' 162 ``r'' 163 ``s'' 164 ``t'' 165 ``u''
166 ``v'' 167 ``w'' 170 ``x'' 171 ``y'' 172 ``z''
173 ``{'' 174 ``|'' 175 ``}'' 176 ``~''
RETURN VALUES
The isgraph() function returns zero if the character tests false and returns non-zero if the character tests true.
COMPATIBILITY
The 4.4BSD extension of accepting arguments outside of the range of the unsigned char type in locales with large character sets is considered
obsolete and may not be supported in future releases. The iswgraph() function should be used instead.
SEE ALSO ctype(3), isalnum_l(3), iswgraph(3), ascii(7)STANDARDS
The isgraph() function conforms to ISO/IEC 9899:1990 (``ISO C90'').
BSD July 17, 2005 BSD