[20190930]oracle raw类型转化number脚本.txt

--//写一个简单oracle raw转化number脚本，简单说明：
--//输入必须是c1,02 或者 c102，不支持c1,2格式。
--//raw2num.sh 脚本放在最后.

--//测试:
$ cat otest.txt | xargs -n 1 -I {} bash -c "./raw2num.sh {};echo {} " | paste - -
0       80
1       c1,02
2       c1,03
25      c1,1a
123     c2,02,18
4100    c2,2a
-4100   3d,3c,66
41000000        c4,2a
-41000000       3b,3c,66
132004078       c5,02,21,01,29,4f
2.01    c1,03,02
.3      c0,1f
.00000125       be,02,1a
115.200003      c2,02,10,15,01,04
-.00000125      41,64,4c,66
-.3     3f,47,66
-1      3e,64,66
-5      3e,60,66
-20032 3c,63,65,45,66
-234.432        3d,63,43,3a,51,66
999999999999999999999999999999999999999900000000000000000000000000000000000000000000000000000000000000000000000000000000000000 ff,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64
-999999999999999999999999999999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 00,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02
.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001     80,02
-.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001    7f,64,66
123456789012345678901234567890123456789000      d5,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b
-123456789012345678901234567890123456780000     2a,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b
.123456789012345678901234567890123456789        c0,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b
-.12345678901234567890123456789012345678        3f,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b

$ cat otest.txt
80
c1,02
c1,03
c1,1a
c2,02,18
c2,2a
3d,3c,66
c4,2a
3b,3c,66
c5,02,21,01,29,4f
c1,03,02
c0,1f
be,02,1a
c2,02,10,15,01,04
41,64,4c,66
3f,47,66
3e,64,66
3e,60,66
3c,63,65,45,66
3d,63,43,3a,51,66
ff,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64,64
00,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02,02
80,02
7f,64,66
d5,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b
2a,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b
c0,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b,0d,23,39,4f,5b
3f,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b,59,43,2d,17,0b

$ cat raw2num.sh
#! /bin/bash
#! oracle raw convert number
odebug=${ODEBUG:-0}

# process input parameter ,delete 0x and "," and all spaces. save to variable v_raw. and its length to variable v_len.
v_raw="$*"
v_raw=${v_raw//0x/}
v_raw=${v_raw//[, ]/}
v_len=${#v_raw}

v_tmp=$(( $v_len % 2 ))
if [ $v_tmp -ne 0 -o $v_len -gt 42 ]; then
echo "$v_raw is illegal! v_len=$v_len or length of v_len>42"
exit 2
fi

if [ $odebug -eq 1 ] ; then
echo v_ram="$v_raw"
fi

if [ "$v_raw" == "80" ]; then
   result=0
   echo "$result"
   exit 0
elif [ "$v_raw" \> "80" ]; then
   v_res="0."
   v_exp=$(printf "%2d" $(( "0x"${v_raw:0:2} - 0xc0 )))

if [ $odebug -eq 1 ] ; then
echo v_ram="$v_raw" v_exp="$v_exp" v_len="$v_len"
fi

for ((i=2;i<$v_len;i+=2))
   do
       v_tmp=$(printf "%02d" $(( "0x"${v_raw:i:2} -0x1 )))
       if [ $v_tmp -lt 0 -o $v_tmp -gt 99 ]; then
           echo "$v_raw is illegal! offset $i = 0x${v_raw:i:2}"
           exit 3
       fi
       if [ $v_tmp -eq 0 -a $i -eq $(( $v_len - 2 )) ];then
           echo "$v_raw is illegal! offset $i = 0x${v_raw:i:2}"
           exit 3
       fi
       v_res=${v_res}${v_tmp}
   done
   #result=$(echo "scale=132; 100^${v_exp} * ${v_res} " | bc -l | tr -d '\n\\\r' | sed -e "s/\.$[0-9]*[1-9]$0\+$/.\1/" -e "s/\.0\+$//")
else
#negative
   v_res="-0."
   v_exp=$(printf "%2d" $(( 0xff - "0x"${v_raw:0:2} -0xc0 )))

## substr last 2 char, normal is 0x66 (102)
v_len=$(( $v_len - 2 ))
v_last=$(printf "%02d" $(( "0x"${v_raw:v_len:2} )))

if [ $odebug -eq 1 ] ; then
       echo v_ram="$v_raw" v_exp="$v_exp" v_len-2="$v_len" v_last="$v_last"
   fi

   if [ "$v_last" != "102" -a $v_len -lt 40 ]; then
       echo "$v_raw is illegal! offset $v_len = 0x${v_raw:v_len:2}"
       exit 4
   fi

for ((i=2;i<$v_len;i+=2))
   do
       v_tmp=$(printf "%02d" $(( 0x65 - "0x"${v_raw:i:2} )))
       if [ $v_tmp -lt 0 -o $v_tmp -gt 99 ]; then
           echo "$v_raw is illegal! offset $i = 0x${v_raw:i:2}"
           exit 3
       fi
       if [ $v_tmp -eq 0 -a $i -eq $(( $v_len - 2 )) ];then
           echo "$v_raw is illegal! offset $i = 0x${v_raw:i:2}"
           exit 3
       fi
       v_res=${v_res}${v_tmp}
   done

   if [ $v_len -eq 42 -a "$v_last" != '102' ]; then
       v_tmp=$(printf "%02d" $(( 101 - $v_last )))
       if [ $v_tmp -le 0 -o $v_tmp -gt 99 ]; then
           echo "$v_raw is illegal! offset $v_len = 0x${v_raw:v_len:2}"
           exit 3
       fi
       v_res=${v_res}${v_last}
   fi
   #result=$(echo "scale=132; 100^${v_exp} * ${v_res} " | bc -l | tr -d '\n\\\r' | sed -e "s/\.$[0-9]*[1-9]$0\+$/.\1/" -e "s/\.0\+$//")
fi

if [ $odebug -eq 1 ] ; then
echo v_ram="$v_raw" v_exp="$v_exp" v_len="$v_len" v_res="$v_res"
fi

result=$(echo "scale=132; 100^${v_exp} * ${v_res} " | bc -l | tr -d '\n\\\r' | sed -e "s/\.$[0-9]*[1-9]$0\+$/.\1/" -e "s/\.0\+$//")

echo "$result"

[20190930]oracle raw类型转化number脚本.txt

相关推荐