這是一個強大的處理格式化文本的工具,通過使用其腳本,幾乎可以把文本當作數據庫處理
分隔符為逗號, 標尺格式化顯示各個字段
gawk -F"," "{printf \"%-6s %-9s %-9s %-9s %-9s\n\", NR, $1, $2, $4, $12}" aStockList.csv
如:
1 代碼 名稱 現價 今開
2 000001 深發展Ａ 40.45 40.7
3 000002 萬 科Ａ 35.8 35.69
4 000004 ST 國 農 9.72 9.91
5 000005 ST 星 源 0 ---
6 000006 深振業Ａ 33.3 33.31
7 000007 ST 達 聲 7.18 7.1
8 000008 *ST 寶投 0 ---
9 000009 S深寶安A 13.59 13.6
10 000010 S ST華新 0 ---
取文件最后一行的行號.實際就是取總行數
gawk "END {print NR}" aStockList.csv
將數據分類匯總
gawk -F"," "{pos=(NR-1)%40; page=int((NR-1)/40); a=int((NR-1)/600) }
{print $1\",\",$2\",\",pos\",\",page\",\",a}" aStockList.csv |
gawk -F"," "BEGIN
{ printf \"%-6s %-9s %-9s %-4s\n\", \" \", \"代碼\", \"名稱\", \"條/頁/位置\";
print \"----------------------------------\" }
{ printf\"%-6s %-9s %-9s %-4s \n\", NR, $1, $2, $5\"/\"$4%15\"/\"$3}"
原始數據:
代碼 ,名稱,漲幅%%,現價,日漲跌,買入價,賣出價,總量,現量,漲速%%,換手%%,今開
000001,深發展Ａ,-0.32,40.45,-0.54,40.45,40.48,90119,32,0.24,0.58,40.7
000002,萬 科Ａ,-0.56,35.8,-0.2,35.79,35.8,172067,3,0.56,0.33,35.69
000004,ST 國 農,-1.82,9.72,-0.18,9.7,9.72,18424,8,0,2.82,9.91
000005,ST 星 源,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000006,深振業Ａ,0,33.3,0,33.22,33.3,8753,6,0.27,0.4,33.31
000007,ST 達 聲,2.43,7.18,0.17,7.15,7.18,11955,2,0.7,0.83,7.1
000008,*ST 寶投,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000009,S深寶安A,-1.02,13.59,-0.14,13.59,13.6,31747,150,0.22,0.55,13.6
000010,S ST華新,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000011,S深物業A,-0.86,12.65,-0.11,12.6,12.65,1608,24,0.39,0.18,12.43
000012,南 玻Ａ,0.17,18.16,0.03,18.16,18.18,32715,149,0.66,0.85,18
000014,沙河股份,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000016,深康佳Ａ,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000017,S ST中華,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000018,ST中冠Ａ,-0.39,7.66,-0.03,7.66,7.67,1182,2,0.13,0.28,7.69
000019,深深寶Ａ,-2.81,17.3,-0.5,17.3,17.38,12168,9,0.69,1.66,17.6
000020,ST華發Ａ,-0.14,6.91,-0.01,6.86,6.91,3235,6,0,0.5,6.91
000021,長城開發,-1.97,15.39,-0.31,15.38,15.39,18408,3,0.39,0.5,15.68
000022,深赤灣Ａ,-3.59,24.45,-0.91,24.45,24.46,5446,9,0.16,0.46,25.18
000023,深天地Ａ,-1.79,10.41,-0.19,10.4,10.41,3878,17,-0.19,0.58,10.78
000024,招商地產,-3.42,87.7,-3.11,87.71,87.99,2213,51,-0.11,0.07,91.9
000025,特 力Ａ,-1.48,13.99,-0.21,13.95,13.99,6856,4,-0.07,1.43,14.18
000026,飛亞達Ａ,-3.49,11.6,-0.42,11.6,11.65,20177,3,0.6,2.54,11.9
000027,深能源Ａ,-0.23,21.3,-0.05,21.28,21.3,30689,5,0.37,0.51,21.4
000028,一致藥業,-1.35,15.38,-0.21,15.31,15.38,6399,3,0.32,0.57,15.58
000029,深深房Ａ,-1.21,7.36,-0.09,7.35,7.36,16261,7,1.51,0.6,7.49
000030,S*ST盛潤,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000031,中糧地產,0.89,27.29,0.24,27.28,27.29,46135,78,0.25,0.94,27.05
000032,深桑達Ａ,-2.2,11.1,-0.25,11.07,11.1,5361,50,0.18,0.47,11.31
000033,新都酒店,-1.94,6.07,-0.12,6.06,6.07,19441,5,0.66,1.23,6.13
000034,SST 深泰,-0.48,8.24,-0.04,8.24,8.27,3797,15,0.12,0.45,8.21
000035,ST 科 健,--- ,0,--- ,--- ,--- ,0,0,--- ,0,---
000036,華聯控股,1.28,7.91,0.1,7.9,7.91,97065,300,0.5,1.26,7.73
000037,深南電Ａ,-1.9,8.25,-0.16,8.24,8.25,8874,62,0.24,0.55,8.4
000039,中集集團,-1.41,23.7,-0.34,23.7,23.72,55243,9,0.21,0.59,24.05
000040,深 鴻 基,-1.96,8.02,-0.16,8.01,8.02,24508,10,0.62,0.62,8.2
000042,深 長 城,-1.42,23.66,-0.34,23.66,23.7,3064,4,0.25,0.23,24.1
000043,深南光Ａ,1.83,23.9,0.43,23.85,23.9,1543,11,0.42,0.17,23.53
000045,深紡織Ａ,-1.88,7.31,-0.14,7.31,7.36,3779,5,-0.67,0.81,7.45
000046,泛海建設,-0.32,59.89,-0.19,59.89,59.9,4754,4,-0.01,0.21,60.11
000048,*ST 康達,-0.95,5.2,-0.05,5.2,5.22,11110,2,0,0.5,5.27
000049,德賽電池,2.26,10.86,0.24,10.85,10.86,8425,44,0.09,1.33,10.62
000050,深天馬Ａ,-0.66,13.58,-0.09,13.56,13.58,10580,4,0.36,0.88,13.76
000055,方 大Ａ,-1.48,7.32,-0.11,7.32,7.33,7959,5,0.68,0.67,7.47
000056,深 國 商,-2.46,11.1,-0.28,11.12,11.19,5911,8,0.45,0.6,11.38
000058,*ST 賽格,-0.21,9.64,-0.02,9.63,9.64,25708,60,-0.41,1.22,9.87
000059,遼通化工,0.27,11.32,0.03,11.31,11.32,62685,28,0.17,1.9,11.32
000060,中金嶺南,2.16,47.2,1,47.18,47.2,135188,3,1.17,3.13,46.19
目標數據:
代碼 名稱 條/頁/位置
----------------------------------
1 000001 深發展Ａ 0/0/ 0
2 000002 萬 科Ａ 0/0/ 1
3 000004 ST 國 農 0/0/ 2
4 000005 ST 星 源 0/0/ 3
5 000006 深振業Ａ 0/0/ 4
6 000007 ST 達 聲 0/0/ 5
7 000008 *ST 寶投 0/0/ 6
8 000009 S深寶安A 0/0/ 7
9 000010 S ST華新 0/0/ 8
10 000011 S深物業A 0/0/ 9
11 000012 南 玻Ａ 0/0/ 10
12 000014 沙河股份 0/0/ 11
13 000016 深康佳Ａ 0/0/ 12
14 000017 S ST中華 0/0/ 13
15 000018 ST中冠Ａ 0/0/ 14
16 000019 深深寶Ａ 0/0/ 15
17 000020 ST華發Ａ 0/0/ 16
18 000021 長城開發 0/0/ 17
19 000022 深赤灣Ａ 0/0/ 18
20 000023 深天地Ａ 0/0/ 19
21 000024 招商地產 0/0/ 20
22 000025 特 力Ａ 0/0/ 21
23 000026 飛亞達Ａ 0/0/ 22
24 000027 深能源Ａ 0/0/ 23
25 000028 一致藥業 0/0/ 24
26 000029 深深房Ａ 0/0/ 25
27 000030 S*ST盛潤 0/0/ 26
28 000031 中糧地產 0/0/ 27
29 000032 深桑達Ａ 0/0/ 28
30 000033 新都酒店 0/0/ 29
31 000034 SST 深泰 0/0/ 30
32 000035 ST 科 健 0/0/ 31
33 000036 華聯控股 0/0/ 32
34 000037 深南電Ａ 0/0/ 33
35 000039 中集集團 0/0/ 34
36 000040 深 鴻 基 0/0/ 35
37 000042 深 長 城 0/0/ 36
38 000043 深南光Ａ 0/0/ 37
39 000045 深紡織Ａ 0/0/ 38
40 000046 泛海建設 0/0/ 39
41 000048 *ST 康達 0/1/ 0
42 000049 德賽電池 0/1/ 1
43 000050 深天馬Ａ 0/1/ 2
44 000055 方 大Ａ 0/1/ 3
45 000056 深 國 商 0/1/ 4
46 000058 *ST 賽格 0/1/ 5
47 000059 遼通化工 0/1/ 6
48 000060 中金嶺南 0/1/ 7
49 000061 農 產 品 0/1/ 8
50 000062 深圳華強 0/1/ 9
51 000063 中興通訊 0/1/ 10
52 000065 北方國際 0/1/ 11