I have some geometric data (X Y) that is in the wrong scale. My raw data is in mills but it needs to be in tenths of a mil
I am pretty familiar with awk and sed
I want to use awk to divide $1 and $2 by .1
I'm just not sure of the syntax $1 and $2 are variables and .1 is fixed
simple math would be -4610.20/.1 = -46102
I need this ...
48.00 -4610.20 J1.3 PREFERRED;
to become this ...
480 -46102 J1.3 PREFERRED;
I have written a small script to turn this ...
| UNNAMED_16_CAPACITOR_I208_B | | 1 | Pin(J1.3) | 62.20 | 348.00,-4610.20 | UNNAMED_16_CAPACITOR_I178_A | |
Below is what i have in my script.
htcount=$(curl -s --user tomcatstatus:tomcatstatus http://`hostname`.mypc.com:887/manager/jmxproxy?qry=Catalina:type=ThreadPool,name=\"http-nio-887\" |grep sBusy | cut -d ' ' -f2)
echo $htcount
if ; then
echo "more than 10"
else
echo "Less than 10"
fi... (6 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)
this code below is very useful in calculating mean and quartiles. however, i would really like to translate it to awk without having to write to any external file:
#!/bin/sh
filename="tmp.txt"
sort -n $1 >$filename
rows=`wc -l $filename|cut -d' ' -f1`
q2=`echo "($rows+1)/2" |bc`
... (3 Replies)
Hi All,
I am using an awk script as below:
awk -F'|' 'BEGIN{OFS="|";} { if ($1==$3 && $3==$7 && $7==$13 && $2==$6 && $6==$11 && $15-$14+1==$11) print $0"|""TRUE"; else print $0"|""FALSE"; }' tempfile.txt
In above script, all conditions are being checked except the one which is... (4 Replies)
Hello,
I have big files which I wanna filter them based on first column.
first column should be one of these strings: chr2L || chr2R || chr3L || chr3R || chr4 || chrX
and something like chr2Lh or chrY or chrM3L is not accepted.
I used the following command:
awk '{ if ($1=="chr2L" ||... (5 Replies)
I do have a shell file where I call many unix commands . I would like to add a regular expression step in that shell file, where a text file, say Test.txt has to be openned and all the :'s should be replaced.
Basically apply the follwoing regular expression:
:%s/://g
to that particular text... (2 Replies)
I'm would to create a script that would give me the results below.
Please note the spaces in the log file are actually commas(",".)
Log file Data
0:00 21:15 899 43 31 12 25.39
0:00 21:20 736 34 19 15 35.39
0:00 21:20 776 41 28 13 ... (3 Replies)
I have the following script:
For catching errors like:
But the regular expression ERROR*memory inside case doesn't seem to be working.
The output of bash -x scriptname is:
Please help (5 Replies)
Ive got a file with words and also numbers.
Bla BLA
10 10
11 29
12 89
13 35
And i need to change "10,29,89,25" and also remove anything that contains actually words... (4 Replies)