Guest User

Untitled

a guest
Jul 19th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. 123711184642,02,3583090366663629,639f02012437d4
  2. 123715942138,01,3538710295145500,639f02afd6c643
  3. 123711616258,02,3548370476972758,639f0200485732
  4.  
  5. 123711184642,02,3583090366663629,639f02,0124,37d4
  6. 123715942138,01,3538710295145500,639f02,afd6,c643
  7. 123711616258,02,3548370476972758,639f02,0048,5732
  8.  
  9. 123711184642,02,3583090366663629,639f02,292,14292
  10. 123715942138,01,3538710295145500,639f02,45014,50755
  11. 123711616258,02,3548370476972758,639f02,72,22322
  12.  
  13. awk $([[ $(awk --version) = GNU* ]] && echo --non-decimal-data) -F, '
  14. BEGIN {OFS = FS}
  15. {
  16. $6 = sprintf("%d", "0x" substr($4, 11, 4))
  17. $5 = sprintf("%d", "0x" substr($4, 7, 4))
  18. $4 = substr($4, 1, 6)
  19. print
  20. }'
  21.  
  22. saveIFS=$IFS
  23. IFS=,
  24. while read -r -a line
  25. do
  26. printf '%s,%s,%d,%dn' "${line[*]:0:3}" "${line[3]:0:6}" "0x${line[3]:6:4}" "0x${line[3]:10:4}"
  27. done
  28. IFS=$saveIFS
  29.  
  30. saveIFS=$IFS
  31. IFS=,
  32. while read -r -a line
  33. do
  34. line[6]=$(printf '%d' "0x${line[3]:10:4}")
  35. line[5]=$(printf '%d' "0x${line[3]:6:4}")
  36. line[4]=$(printf '%s' "${line[3]:0:6}")
  37. printf '%sn' "${line[*]}"
  38. done
  39. IFS=$saveIFS
  40.  
  41. awk -F, '{ p1 = substr($4, 1, 6);
  42. p2 = ("0x" substr($4, 7, 4)) + 0;
  43. p3 = ("0x" substr($4, 11, 4)) + 0;
  44. printf "%s,%s,%s,%s,%d,%dn", $1, $2, $3, p1, p2, p3;
  45. }'
  46.  
  47. 123711184642,02,3583090366663629,639f02,292,14292
  48. 123715942138,01,3538710295145500,639f02,45014,50755
  49. 123711616258,02,3548370476972758,639f02,72,22322
  50.  
  51. awk -F, '{ p1 = substr($4, 1, 6);
  52. p2 = "0x" substr($4, 7, 4);
  53. p3 = "0x" substr($4, 11, 4);
  54. printf "%s,%s,%s,%s,%d,%dn", $1, $2, $3, p1, p2, p3;
  55. }'
  56.  
  57. gawk -F, '{ p1 = substr($4, 1, 6);
  58. p2 = "0x" substr($4, 7, 4);
  59. p3 = "0x" substr($4, 11, 4);
  60. printf "%s,%s,%s,%s,%d,%dn", $1, $2, $3, p1, strtonum(p2), strtonum(p3);
  61. }'
  62.  
  63. function parsehex(V,OUT)
  64. {
  65. if(V ~ /^0x/) V=substr(V,3);
  66.  
  67. for(N=1; N<=length(V); N++)
  68. OUT=(OUT*16) + H[substr(V, N, 1)]
  69.  
  70. return(OUT)
  71. }
  72.  
  73. BEGIN { for(N=0; N<16; N++)
  74. { H[sprintf("%x",N)]=N; H[sprintf("%X",N)]=N } }
  75.  
  76. { print parsehex($1) }
  77.  
  78. awk '{cmd="printf %d 0x" $1; cmd | getline decimal; close(cmd); print decimal}'
  79.  
  80. awk 'BEGIN{cmd="printf "%dn""}{cmd=cmd " 0x" $1}END{while ((cmd | getline dec) > 0) { print dec }; close(cmd)}'
  81.  
  82. awk -Wposix '{printf("%dn","0x" $1)}'
  83.  
  84. awk $(awk -Wversion >/dev/null 2>&1 && printf -- "-Wposix") '{printf("%dn","0x" $1)}'
  85.  
  86. cat all_info_List.csv| awk 'BEGIN {FS="|"}{print $21}'| awk 'BEGIN {FS=":"}{p1=$1":"$2":"$3":"$4":"$5":"; p2 = strtonum("0x"$6); printf("%s%02Xn",p1,p2+1) }'
  87.  
  88. sed -r 's/(....)(....)$/ 0x1 0x2/;s/.*/printf "%s,%d,%d" &/e' file
  89.  
  90. printf "%dn", strtonum( "0x"$1 )"
  91.  
  92. perl -F, -lane '$p1 = substr($F[3], 0, 6); $p2 = substr($F[3], 6, 4); $p3 = substr($F[3], 10, 4); printf "%s,%s,%s,%s,%d,%dn", @F[0..2], $p1, hex($p2), hex($p3)' file
  93.  
  94. 123711184642,02,3583090366663629,639f02,292,14292
  95. 123715942138,01,3538710295145500,639f02,45014,50755
  96. 123711616258,02,3548370476972758,639f02,72,22322
Add Comment
Please, Sign In to add comment