API tools faq
paste
Guest User

Untitled

a guest
Nov 12th, 2018
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.07 KB | None | 0 0
raw download clone embed print report
  1. ---------------------------
  2. |Data statistics|Number of|
  3. |-------------------------|
  4. |Records passed | 750,517|
  5. ---------------------------
  6. Transaction Data for Serial Numbers
  7.  
  8. No of Records : 750517
  9.  
  10. -----------------------------------------------------------------------------------------------------------
  11. |Material Number|Serial Number From |Serial Number To |Document Year|Delivery Document|Material Document|
  12. |----------------------------------------------------------------------------------------------------------
  13. |200965 |18604165309338 |18604165309387 |2012 |6100202749 |AAA2778202 |
  14. |201163 |10740000822407 |10740000822606 |2012 |6100202749 |AAA2778202 |
  15. |201232 |18604177741067 |18604177741366 |2012 |6100202749 |AAA2778202 |
  16. |201295 |18604221522337 |18604221523836 |2012 |6100202749 |AAA2778202 |
  17. |201480 |18604113309952 |18604113310131 |2012 |6100202749 |AAA2778202 |
  18. |201781 |18604199150436 |18604199150835 |2012 |6100202749 |AAA2778202 |
  19. |201480 |6001400030046472 |6001400030046771 |2012 |6100202520 |AAA2777953 |
  20. |202853 |6001700000180323 |6001700000180722 |2012 |6100202520 |AAA2777953 |
  21. -----------------------------------------------------------------------------------------------------------
  22.  
  23. awk ' BEGIN {FS ="|"; OFS = ","} { if ($2~"2") print $2,$3,$4,$5,$6,$7 }' Input.txt
  24.  
  25. 200965 ,18604165309338 ,18604165309387 ,2012 ,6100202749 ,AAA2778202
  26. 201163 ,10740000822407 ,10740000822606 ,2012 ,6100202749 ,AAA2778202
  27. 201232 ,18604177741067 ,18604177741366 ,2012 ,6100202749 ,AAA2778202
  28. 201295 ,18604221522337 ,18604221523836 ,2012 ,6100202749 ,AAA2778202
  29. 201480 ,18604113309952 ,18604113310131 ,2012 ,6100202749 ,AAA2778202
  30. 201781 ,18604199150436 ,18604199150835 ,2012 ,6100202749 ,AAA2778202
  31. 201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  32. 202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
  33.  
  34. $ awk 'gsub(/|/,",") && gsub(/^,|,$/,"") && /^2/' file
  35. 200965 ,18604165309338 ,18604165309387 ,2012 ,6100202749 ,AAA2778202
  36. 201163 ,10740000822407 ,10740000822606 ,2012 ,6100202749 ,AAA2778202
  37. 201232 ,18604177741067 ,18604177741366 ,2012 ,6100202749 ,AAA2778202
  38. 201295 ,18604221522337 ,18604221523836 ,2012 ,6100202749 ,AAA2778202
  39. 201480 ,18604113309952 ,18604113310131 ,2012 ,6100202749 ,AAA2778202
  40. 201781 ,18604199150436 ,18604199150835 ,2012 ,6100202749 ,AAA2778202
  41. 201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  42. 202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
  43.  
  44. $ awk 'gsub(/|/,",") && gsub(/^,|,$/,"") && $3~/^,600/' file
  45. 201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  46. 202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
  47.  
  48. $ awk -F, 'gsub(/|/,",") && gsub(/^,|,$/,"") && $3~/^600/' file
  49. 201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  50. 202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
  51.  
  52. $ awk -F"|" -v OFS="," '$2~/^2/ {NF--; $0=$0; print}' file
  53. ,200965 ,18604165309338 ,18604165309387 ,2012 ,6100202749 ,AAA2778202
  54. ,201163 ,10740000822407 ,10740000822606 ,2012 ,6100202749 ,AAA2778202
  55. ,201232 ,18604177741067 ,18604177741366 ,2012 ,6100202749 ,AAA2778202
  56. ,201295 ,18604221522337 ,18604221523836 ,2012 ,6100202749 ,AAA2778202
  57. ,201480 ,18604113309952 ,18604113310131 ,2012 ,6100202749 ,AAA2778202
  58. ,201781 ,18604199150436 ,18604199150835 ,2012 ,6100202749 ,AAA2778202
  59. ,201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  60. ,202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
  61.  
  62. $ cat file
  63. ---------------------------
  64. |Data statistics|Number of|
  65. |-------------------------|
  66. |Records passed | 750,517|
  67. ---------------------------
  68. Transaction Data for Serial Numbers
  69.  
  70. No of Records : 750517
  71.  
  72. -----------------------------------------------------------------------------------------------------------
  73. |Material Number|Serial Number From |Serial Number To |Document Year|Delivery Document|Material Document|
  74. |----------------------------------------------------------------------------------------------------------
  75. |200965 |18604165309338 |18604165309387 |2012 |6100202749 |AAA2778202 |
  76. |201163 |10740000822407 |10740000822606 |2012 |6100202749 |AAA2778202 |
  77. |201232 |18604177741067 |18604177741366 |2012 |6100202749 |AAA2778202 |
  78. |201295 |18604221522337 |18604221523836 |2012 |6100202749 |AAA2778202 |
  79. |201480 |18604113309952 |18604113310131 |2012 |6100202749 |AAA2778202 |
  80. |201781 |18604199150436 |18604199150835 |2012 |6100202749 |AAA2778202 |
  81. |201480 |6001400030046472 |6001400030046771 |2012 |6100202520 |AAA2777953 |
  82. |202853 |6001700000180323 |6001700000180722 |2012 |6100202520 |AAA2777953 |
  83. -----------------------------------------------------------------------------------------------------------
  84.  
  85. $ awk 's=$1~/^|2/{gsub(/^|||$/,""); gsub(/|/,",")}s' file
  86. 200965 ,18604165309338 ,18604165309387 ,2012 ,6100202749 ,AAA2778202
  87. 201163 ,10740000822407 ,10740000822606 ,2012 ,6100202749 ,AAA2778202
  88. 201232 ,18604177741067 ,18604177741366 ,2012 ,6100202749 ,AAA2778202
  89. 201295 ,18604221522337 ,18604221523836 ,2012 ,6100202749 ,AAA2778202
  90. 201480 ,18604113309952 ,18604113310131 ,2012 ,6100202749 ,AAA2778202
  91. 201781 ,18604199150436 ,18604199150835 ,2012 ,6100202749 ,AAA2778202
  92. 201480 ,6001400030046472 ,6001400030046771 ,2012 ,6100202520 ,AAA2777953
  93. 202853 ,6001700000180323 ,6001700000180722 ,2012 ,6100202520 ,AAA2777953
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!