Use decimal value of array in bc ends with illegal character
hi all
I have to read a long cvs file every 4 columns with decimal "3,45" numbers.
The 9th row in this cvs is the first line I need, so it I tail -n+9.
I use sed -e 's/,/./g' to get decimal values with . delimiter.
So far no problem.
Goal is to get two maximum negative forces in ranges 56-66 degrees and 33-55 degrees.
Just for better understanding:
one test case is a set of two direction (open and close)
open and close have both an value of angel in degrees and a value force in Newton.
Here is a table header of three test cases. The original csv file has thousands and around 340 rows of angel/force combinations.
Code:
;test no 3;;;;test no 2;;;;test no 1;;;;
;process open;;process close;process open;;process close;process open;;process close
;angel;force;angel;force;angel;force;angel;force;angel;force;angel;force
;68,09;8,88;0,4;0,6;68,27;8,46;0,21;0,7;68,27;8,8;0,21;0,64
;67,44;0,19;0,12;3,41;67,72;0,35;0,03;2,65;67,72;0,26;0,03;2,2
;66,62;1,5;0,05;0,73;67,08;0,37;0,24;0,05;66,89;0,28;0,24;0,38
;60,46;-4,39;4,65;0,92;60,46;-4,79;5,02;0,82;60,55;-4,65;5,2;0,92
.....
What I need to get working is the commented if-statement.
Code:
#!/bin/bash
csv=${1:-"/home/my/test.csv"}
val1_angel_high=66
val1_angel_low=56
val2_angel_high=55
val2_angel_low=33
no_cols=$(head -n 1 "${csv}" | awk -F";" '{ print NF}')
no_val_pairs=$((((no_cols--))/4))
while [ $no_cols -gt 1 ]; do
angelCollection_process_1=( $(tail -n+9 "${csv}" | cut -d ';' -f "$no_cols" | sed -e 's/,/./g') )
forceCollection_process_1=( $(tail -n+9 "${csv}" | cut -d ';' -f "$((no_cols+1))" | sed -e 's/,/./g') )
#printf "Process 1 - Angel: %s Force: %s\n" "${angelCollection_process_1[@]}" "${forceCollection_process_1[@]}"
position=0
max_force=0.0;
for t in "${angelCollection_process_1[@]}"; do
if (( $(bc <<< "$t <= $val1_angel_high") && $(bc <<< "$t >= $val1_angel_low") )); then
#echo $t : $max_force">"${forceCollection_process_1[$position]}; #works
force="${forceCollection_process_1[$position]}";
echo $max_force $force; #works
force2=$(bc <<< "$force*100");
echo $force2; # not working (standard_in) 1: illegal character: ^M
#if (( $(bc <<< "${forceCollection_process_1[$position]} < $max_force") )); then
# max_force="${forceCollection_process_1[$position]}";
#fi
fi
((position++))
done
echo $max_force
no_cols=$((no_cols-4))
done
Hope you find a solution how I can use the value from array in bc.
Other solutions are also welcome. I try to use perl also, but I failed with reading csv every 4 columns.
Hi all.
I want to use sed to remove a word that ends with "!" in the first page of a file. The word I want to remove is: "DNA!".
I have search for an answer and nothing of what I found helped me.
~faizlo (2 Replies)
somedata | awk -F"#soils#" '{split($1,a,"NITNUM="); print a}'
how can i edit the content of array 2 above?
what i want to do is get rid of single quotes and double quotes. and then turn the "NewLine" into new lines.
the data in array 2 (a) is:
... (2 Replies)
Hi ,
seq can be 0...128
int windex = seq / 8;
int bindex = seq % 8;
unsigned char bitvalue = '\x01' << (7-bindex) ;
bpv.bitmapvalue = bitvalue;
This is the part of a program to convert decimal to bitmap value of hexadecimal.
I want this to change to convert only to... (1 Reply)
Trying to do some control flow parsing based on the index postion of an array member. Here is the pseudo code I am trying to write in (preferably in pure bash) where possible. I am thinking regex with do the trick, but need a little help.
pesudo code
if == ENDSINFIVEINTS ]]; then
do... (4 Replies)
HI All ,
I am using AIX version 6 . having issue with below perl code,
sub Article ($procudure, @params) {
my ($procudure, @params) = @_;
#Get handle TO Dataware House DATABASE
try {
my $dbHandle = &Cobol::DBAccess::getDBDwConnection();
,,,,,,,,,,,,,
,,,,,,,,,,,,... (3 Replies)
I am seeing an special character in my file
when i do the
cat filename | od-bc
I see a value of 376 for that special character.
I would like to find the decimal value for the character.
For example the decimal value for ctrl-Y is char(25).
Appreciate help on this. (11 Replies)
Hi all,
I have a input like this
3AF9:3B01
and need to expand to the below output
3AF9
3AFA
3AFB
3AFC
3AFD
3AFE
3AFF
3B00
3B01
Please let me know the easiest way for achieving this. Thanks for the help in advance... (6 Replies)
Hi !
I'm having problem with assigning values to a multidimensional character array.
i wanted to have an array with 48 fields ,each filed being of varying size and hence have declared the array as
char struct_arr;
I am trying to assign values to the fileds as
struct_arr = token
... (1 Reply)
If i have a variable which is a decimal number, i.e 34.05 How can you make decimal point fall on the 15th character on the screen? Or any other that you can specify? Can you do it using sed or awk? (3 Replies)
09-17-2015
