Shell Programming and Scripting

For supressing the spaces u can use

tr -s ' '


And if u have both tabs and spaces in ur file u can use awk instead of cut.

for ex:

instead of
cut -f3 -d" "

U can use
awk '{print $3}'

I have a file like this....

BSC5-64-1 BSC7-1-1 99.00 99.00
BSC5-64-2 BSC7-1-1 98.00 98.00
BSC7-1-1 BSC7-1-2 -1.00 -1.00
BSC7-1-1 BSC7-1-3 -1.00 -1.00
BSC5-70-1 BSC7-1-1 99.00 99.00
BSC5-70-2 BSC7-1-1 99.00 99.00
BSC7-1-1 BSC7-2-1 -1.00 0.00
BSC7-1-1 BSC7-2-2 17.00 17.00
BSC7-1-1 BSC7-2-3 0.00 4.00
BSC7-1-1 BSC7-3-1 9.00 10.00
BSC7-1-1 BSC7-3-2 34.00 27.00
BSC7-1-1 BSC7-3-3 21.00 26.00
..........................................................
..........................................................
BSC7-1-1 BSC7-4-1 19.00 13.00
BSC7-1-1 BSC7-4-2 35.00 6.00
BSC7-1-1 BSC7-4-3 14.00 23.00
BSC7-1-1 BSC7-5-1 36.00 44.00
BSC7-1-1 BSC7-5-2 44.00 23.00
BSC5-64-1 BSC7-1-1 99.00 99.00
BSC5-64-2 BSC7-1-1 98.00 98.00
i need format this file so...
if first column is BSC7-1-1, then its ok..
else move second column to first and 4-th to 3-d..
....
can anyone help me????/

This is a different question so you should really start a new thread, but anyway try this...

Code:

awk '$1!="BSC7-1-1"{$0=$2 FS $1 FS $4 FS $3}1' file1

Regarding my first question I'm using Mona's code but when I try to calculate a number bigger than 2500000000 it give the wrong answer. I guess some where around 2500000000 is the max number but is there a way to do calculations using numbers bigger than 2500000000?

e.g. Input file with below:

AAA Unit1 2500000000 500000000

using Mona's code it should output "AAA 0.2" but it outputs "AAA -0.27"

Did you find any solution for this? It works fine for me. I am getting the below output,

AAA .20
BBB .75
CCC .50

provided the input is,

AAA Unit1 60 39
AAA Unit7 30 15
AAA Unit1 2500000000 500000000
BBB Unit3 80 60
CCC Unit4 50 25