求助!!如何格式化下面的内容!!

古道西风

把下面的内容:
gf_geoshare: 300 0
gf_app_builder: 100 0
gf_user_application: 100 0
gf_charisma_attributemap: 100 0
gf_iesx_autopix: 100 0
gf_welledit_bkz: 100 0
gf_basemap_plus: 1200 0
gf_runtime: 500 27
dbwjl hp2036 6/4 7:46
hmjhy hp2045 6/3 15:26
hmlgd hp1017 6/3 15:14
hmrrj hp1078 6/2 8:42
hmssy hp1089 6/2 19:44
hmtmy hp1078 5/22 14:53
lbj_zg hp2045 5/31 15:19
lsx_zc hp1083 6/2 9:36
lxy_zg hp1077 6/3 15:41
nkk_zc hp1089 6/1 8:13
nkk_zc hp1085 6/3 8:59
qy_zg hp1084 6/1 9:06
sjkhf hp1089 6/3 8:18
sjkwsl hp1089 6/3 9:44
szx_zg hp1084 6/1 7:55
wfx_zc hp1082 6/3 14:39
wxw_zc hp1089 6/3 8:03
wzj_zc hp1083 6/3 9:28
xbfdy hp1073 6/3 20:07
xbmfl xb34001 6/3 8:32
xbmfl hp1088 6/2 8:39
xm_zg hp1015 6/3 9:28
ywy_zg hp1088 5/27 16:50
zdr_zc hp1085 6/1 8:41
zhwfj hp1093 5/31 14:16
zxj_zc hp1085 6/2 16:26
zyt_zg hp1077 6/1 8:18
gf_basemap: 400 0
gf_hardcopy: 600 0
gf_data_manager: 500 6
dbwjl hp2036 6/4 8:00
hmjhy hp2045 6/3 15:27
hmrrj hp1078 6/2 10:03
wzj_zc hp1083 6/3 9:42
xbmfl xb34001 6/3 8:43
zdr_zc hp1085 6/3 15:11
gf_dlis_util: 600 0
gf_dlisu: 600 0
gf_cps3_mapping: 500 1
xbmfl hp1088 6/2 8:39
gf_charisma_asap: 100 0
gf_synthetics: 1000 3
lsx_zc hp1083 6/3 11:12
nkk_zc hp1085 6/3 9:02
nkk_zc hp1089 6/1 8:13
gf_geoviz_explore: 1400 0
gf_geoviz: 500 0
gf_iesx_csa: 500 1
szx_zg hp1084 6/3 14:07
gf_coreimage: 100 0
gf_xsection: 500 1
xm_zg hp1015 6/4 7:26
gf_dimqc: 100 0
gf_dip_image: 100 0
gf_dip_image_AWS: 100 0
gf_dip_image_HLS: 100 0
gf_bornor: 100 0
gf_elanplus: 100 0
gf_ressum: 300 0
gf_charisma_hardcopyadv: 100 0
gf_framework_3d: 100 0
gf_modeling_office: 200 0
gf_wellcomposite_plus: 600 0
gf_charisma_seismicviewer: 500 0
gf_welledit: 900 0
gf_preplus: 300 0
gf_petroviewplus: 300 0
gf_charisma_main2d: 400 0
gf_charisma_main3d: 400 0
gf_iesx_seis2d: 700 0
gf_iesx_seis3dv: 700 17
dbwjl hp2036 6/4 7:47
hmjhy hp2045 6/3 15:27
hmlgd hp1017 6/3 15:14
hmrrj hp1078 6/2 8:43
lsx_zc hp1083 6/3 9:40
lxy_zg hp1077 6/3 15:42
nkk_zc hp1085 6/3 9:00
qy_zg hp1084 6/1 9:08
szx_zg hp1084 6/2 7:54
wfx_zc hp1082 6/3 14:39
wzj_zc hp1083 6/3 9:30
xbfdy hp1073 6/3 20:10
xbmfl xb34001 6/3 8:33
xm_zg hp1015 6/3 9:44
zdr_zc hp1085 6/3 15:10
zhwfj hp1093 5/31 14:23
zxj_zc hp1085 6/3 7:52
gf_charisma_geocube: 100 0
gf_charisma_correlationmap: 100 0
gf_reportgenerator: 100 0
gf_geoplot: 300 0
gf_data_functioning: 700 0
gf_wellpix: 200 0
gf_panorama: 300 0
gf_lithotoolkit: 600 0
gf_lo_lql: 200 0
gf_lo_neuralnet: 200 0
gf_log_property: 200 0
gf_iesx_asap: 100 0
gf_iesx_cormap: 200 0
gf_iesx_seistie: 400 0
gf_iesx_seisan: 600 0
gf_indepth: 100 0
gf_cps3_idgn_out: 100 0
gf_lo_clustering: 100 0
gf_lo_histogram: 100 0
gf_charisma_mistie: 100 0
gf_petrostat: 100 0
gf_polaris: 100 0
gf_sediview: 100 0
gf_seisclass: 100 0
gf_seisclass_explore: 200 0
gf_sequence: 100 0
gf_spectral_decomposition: 100 0
gf_statpack: 100 0
gf_strucview: 100 0
gf_iesx_surfaceslice: 100 0
gf_variance_cube: 100 0
gf_wellsketch: 100 0
gf_writeon: 100 0
格式化成:
<featrue name=gf_geoshare total=300 use=0>
</featrue>
<featrue name=gf_app_builder total=100 use=0>
</featrue>
<featrue name=gf_user_application total=100 use=0>
</featrue>
<featrue name=gf_charisma_attributemap total=100 use=0>
</featrue>
<featrue name=gf_iesx_autopix total=100 use=0>
</featrue>
<featrue name=gf_welledit_bkz total=100 use=0>
</featrue>
<featrue name=gf_basemap_plus total=1200 use=0>
</featrue>
<featrue name=gf_basemap_plus total=500 use=0>
<featrue name=gf_runtime total=500 use=27>
<username>dbwjl</username>
<hostname>hp2036</hostname>
<usedate>6/4</usedate>
<usetime>7:46<usetime>
<username>hmjhy</username>
<hostname>hp2045</hostname>
<usedate>6/3</usedate>
<usetime>15:26<usetime>
<username>hmlgd</username>
<hostname>hp1017</hostname>
<usedate>6/3</usedate>
<usetime>15:14<usetime>
<username>hmrrj</username>
<hostname>hp1078</hostname>
<usedate>6/2</usedate>
<usetime>8:42<usetime>
<username>hmssy</username>
<hostname>hp1089</hostname>
<usedate>6/2</usedate>
<usetime>19:44<usetime>
<username>hmtmy</username>
<hostname>hp1078</hostname>
<usedate>5/22</usedate>
<usetime>14:53<usetime>
<username>lbj_zg</username>
<hostname>hp2045</hostname>
<usedate>5/31</usedate>
<usetime>15:19<usetime>
<username>lsx_zc</username>
<hostname>hp1083</hostname>
<usedate>6/2</usedate>
<usetime>9:36<usetime>
<username>lxy_zg</username>
<hostname>hp1077</hostname>
<usedate>6/3</usedate>
<usetime>15:41<usetime>
<username>nkk_zc</username>
<hostname>hp1089</hostname>
<usedate>6/1</usedate>
<usetime>8:13<usetime>
<username>nkk_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>8:59<usetime>
<username>qy_zg</username>
<hostname>hp1084</hostname>
<usedate>6/1</usedate>
<usetime>9:06<usetime>
<username>sjkhf</username>
<hostname>hp1089</hostname>
<usedate>6/3</usedate>
<usetime>8:18<usetime>
<username>sjkwsl</username>
<hostname>hp1089</hostname>
<usedate>6/3</usedate>
<usetime>9:44<usetime>
<username>szx_zg</username>
<hostname>hp1084</hostname>
<usedate>6/1</usedate>
<usetime>7:55<usetime>
<username>wfx_zc</username>
<hostname>hp1082</hostname>
<usedate>6/3</usedate>
<usetime>14:39<usetime>
<username>wxw_zc</username>
<hostname>hp1089</hostname>
<usedate>6/3</usedate>
<usetime>8:03<usetime>
<username>wzj_zc</username>
<hostname>hp1083</hostname>
<usedate>6/3</usedate>
<usetime>9:28<usetime>
<username>xbfdy</username>
<hostname>hp1073</hostname>
<usedate>6/3</usedate>
<usetime>20:07<usetime>
<username>xbmfl</username>
<hostname>xb34001</hostname>
<usedate>6/3</usedate>
<usetime>8:32<usetime>
<username>xbmfl</username>
<hostname>hp1088</hostname>
<usedate>6/2</usedate>
<usetime>8:39<usetime>
<username>xm_zg</username>
<hostname>hp1015</hostname>
<usedate>6/3</usedate>
<usetime>9:28<usetime>
<username>ywy_zg</username>
<hostname>hp1088</hostname>
<usedate>5/27</usedate>
<usetime>16:50<usetime>
<username>zdr_zc</username>
<hostname>hp1085</hostname>
<usedate>6/1</usedate>
<usetime>8:41<usetime>
<username>zhwfj</username>
<hostname>hp1093</hostname>
<usedate>5/31</usedate>
<usetime>14:16<usetime>
<username>zxj_zc</username>
<hostname>hp1085</hostname>
<usedate>6/2</usedate>
<usetime>16:26<usetime>
<username>zyt_zg</username>
<hostname>hp1077</hostname>
<usedate>6/1</usedate>
<usetime>8:18<usetime>
</featrue>
<featrue name=gf_basemap total=400 use=0>
</featrue>
<featrue name=gf_hardcopy total=600 use=0>
</featrue>
<featrue name=gf_data_manager total=500 use=6>
<username>hmjhy</username>
<hostname>hp2045</hostname>
<usedate>6/3</usedate>
<usetime>15:27<usetime>
<username>hmrrj</username>
<hostname>hp1078</hostname>
<usedate>6/2</usedate>
<usetime>10:03<usetime>
<username>wzj_zc</username>
<hostname>hp1083</hostname>
<usedate>6/3</usedate>
<usetime>9:42<usetime>
<username>xbmfl</username>
<hostname>xb34001</hostname>
<usedate>6/3</usedate>
<usetime>8:43<usetime>
<username>zdr_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>15:11<usetime>
</featrue>
<featrue name=gf_dlis_util total=600 use=0>
</featrue>
<featrue name=gf_dlisu total=600 use=0>
</featrue>
<featrue name=gf_cps3_mapping total=500 use=1>
<username>xbmfl</username>
<hostname>hp1088</hostname>
<usedate>6/2</usedate>
<usetime>8:39<usetime>
</featrue>
<featrue name=gf_charisma_asap total=100 use=0>
</featrue>
<featrue name=NOT_LICENSE_MANAGED total= use=>
</featrue>
<featrue name=gf_synthetics total=1000 use=3>
<username>lsx_zc</username>
<hostname>hp1083</hostname>
<usedate>6/3</usedate>
<usetime>11:12<usetime>
<username>nkk_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>9:02<usetime>
<username>nkk_zc</username>
<hostname>hp1089</hostname>
<usedate>6/1</usedate>
<usetime>8:13<usetime>
</featrue>
<featrue name=gf_geoviz_explore total=1400 use=0>
</featrue>
<featrue name=gf_geoviz total=500 use=0>
</featrue>
<featrue name=gf_iesx_csa total=500 use=1>
<username>szx_zg</username>
<hostname>hp1084</hostname>
<usedate>6/3</usedate>
<usetime>14:07<usetime>
</featrue>
<featrue name=gf_coreimage total=100 use=0>
</featrue>
<featrue name=gf_xsection total=500 use=1>
<username>xm_zg</username>
<hostname>hp1015</hostname>
<usedate>6/4</usedate>
<usetime>7:26<usetime>
</featrue>
<featrue name=gf_dimqc total=100 use=0>
</featrue>
<featrue name=gf_dip_image total=100 use=0>
</featrue>
<featrue name=gf_dip_image_AWS total=100 use=0>
</featrue>
<featrue name=gf_dip_image_HLS total=100 use=0>
</featrue>
<featrue name=gf_bornor total=100 use=0>
</featrue>
<featrue name=gf_elanplus total=100 use=0>
</featrue>
<featrue name=gf_ressum total=300 use=0>
</featrue>
<featrue name=gf_charisma_hardcopyadv total=100 use=0>
</featrue>
<featrue name=gf_framework_3d total=100 use=0>
</featrue>
<featrue name=gf_modeling_office total=200 use=0>
</featrue>
<featrue name=gf_wellcomposite_plus total=600 use=0>
</featrue>
<featrue name=gf_charisma_seismicviewer total=500 use=0>
</featrue>
<featrue name=gf_welledit total=900 use=0>
</featrue>
<featrue name=gf_preplus total=300 use=0>
</featrue>
<featrue name=gf_petroviewplus total=300 use=0>
</featrue>
<featrue name=gf_charisma_main2d total=400 use=0>
</featrue>
<featrue name=gf_charisma_main3d total=400 use=0>
</featrue>
<featrue name=gf_iesx_seis2d total=700 use=0>
</featrue>
<featrue name=gf_iesx_seis3dv total=700 use=17>
<username>dbwjl</username>
<hostname>hp2036</hostname>
<usedate>6/4</usedate>
<usetime>7:47<usetime>
<username>hmjhy</username>
<hostname>hp2045</hostname>
<usedate>6/3</usedate>
<usetime>15:27<usetime>
<username>hmlgd</username>
<hostname>hp1017</hostname>
<usedate>6/3</usedate>
<usetime>15:14<usetime>
<username>hmrrj</username>
<hostname>hp1078</hostname>
<usedate>6/2</usedate>
<usetime>8:43<usetime>
<username>lsx_zc</username>
<hostname>hp1083</hostname>
<usedate>6/3</usedate>
<usetime>9:40<usetime>
<username>lxy_zg</username>
<hostname>hp1077</hostname>
<usedate>6/3</usedate>
<usetime>15:42<usetime>
<username>nkk_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>9:00<usetime>
<username>qy_zg</username>
<hostname>hp1084</hostname>
<usedate>6/1</usedate>
<usetime>9:08<usetime>
<username>szx_zg</username>
<hostname>hp1084</hostname>
<usedate>6/2</usedate>
<usetime>7:54<usetime>
<username>wfx_zc</username>
<hostname>hp1082</hostname>
<usedate>6/3</usedate>
<usetime>14:39<usetime>
<username>wzj_zc</username>
<hostname>hp1083</hostname>
<usedate>6/3</usedate>
<usetime>9:30<usetime>
<username>xbfdy</username>
<hostname>hp1073</hostname>
<usedate>6/3</usedate>
<usetime>20:10<usetime>
<username>xbmfl</username>
<hostname>xb34001</hostname>
<usedate>6/3</usedate>
<usetime>8:33<usetime>
<username>xm_zg</username>
<hostname>hp1015</hostname>
<usedate>6/3</usedate>
<usetime>9:44<usetime>
<username>zdr_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>15:10<usetime>
<username>zhwfj</username>
<hostname>hp1093</hostname>
<usedate>5/31</usedate>
<usetime>14:23<usetime>
<username>zxj_zc</username>
<hostname>hp1085</hostname>
<usedate>6/3</usedate>
<usetime>7:52<usetime>
</featrue>
<featrue name=gf_charisma_geocube total=100 use=0>
</featrue>
<featrue name=gf_charisma_correlationmap total=100 use=0>
</featrue>
<featrue name=gf_reportgenerator total=100 use=0>
</featrue>
<featrue name=gf_geoplot total=300 use=0>
</featrue>
<featrue name=gf_data_functioning total=700 use=0>
</featrue>
<featrue name=gf_wellpix total=200 use=0>
</featrue>
<featrue name=gf_panorama total=300 use=0>
</featrue>
<featrue name=gf_lithotoolkit total=600 use=0>
</featrue>
<featrue name=gf_lo_lql total=200 use=0>
</featrue>
<featrue name=gf_lo_neuralnet total=200 use=0>
</featrue>
<featrue name=gf_log_property total=200 use=0>
</featrue>
<featrue name=gf_iesx_asap total=100 use=0>
</featrue>
<featrue name=gf_iesx_cormap total=200 use=0>
</featrue>
<featrue name=gf_iesx_seistie total=400 use=0>
</featrue>
<featrue name=gf_iesx_seisan total=600 use=0>
</featrue>
<featrue name=gf_indepth total=100 use=0>
</featrue>
<featrue name=gf_cps3_idgn_out total=100 use=0>
</featrue>
<featrue name=gf_lo_clustering total=100 use=0>
</featrue>
<featrue name=gf_lo_histogram total=100 use=0>
</featrue>
<featrue name=gf_charisma_mistie total=100 use=0>
</featrue>
<featrue name=gf_petrostat total=100 use=0>
</featrue>
<featrue name=gf_polaris total=100 use=0>
</featrue>
<featrue name=gf_sediview total=100 use=0>
</featrue>
<featrue name=gf_seisclass total=100 use=0>
</featrue>
<featrue name=gf_seisclass_explore total=200 use=0>
</featrue>
<featrue name=gf_sequence total=100 use=0>
</featrue>
<featrue name=gf_spectral_decomposition total=100 use=0>
</featrue>
<featrue name=gf_statpack total=100 use=0>
</featrue>
<featrue name=gf_strucview total=100 use=0>
</featrue>
<featrue name=gf_iesx_surfaceslice total=100 use=0>
</featrue>
<featrue name=gf_variance_cube total=100 use=0>
</featrue>
<featrue name=gf_wellsketch total=100 use=0>
</featrue>

[ 本帖最后由 古道西风 于 2009-6-4 08:21 编辑 ]

springwind426

1. 
   
2. perl -lane '
   
3. if(3==@F){printf "<featrue name=%s total=%d use=%d>\n",$F[0],$F[1],$F[2];$n=$F[2];}
   
4. elsif($n>0){printf "\t<username>%s</username>\n\t<hostname>%s</hostname>\n\t<usedate>%s</usedate>\n\t<usetime>%s</usetime>\n",$F[0],$F[1],$F[2],$F[3];$n--}
   
5. print "</featrue>" unless $n;
   
6. '  数据文件
   

复制代码

分析了一下，似乎当有三个字段，而且最后一个字段不为0的时候，后面的就是4个字段的内容，也就是需要包围在<featrue>..</featrue>中的内容。

lucash

格式化后的结果里的第三行那个use＝49，这个49怎么来的阿？原文里没有阿 ？

[ 本帖最后由 lucash 于 2009-6-3 19:17 编辑 ]

lucash

如果就只有这一段的话：

1. awk '/gf_welledit/{print"<featrue name="$1,"total="$2,"use="$3">\n</featrue>"};/runtime/{if ($5=="") print"<featrue name="$1,"total="$2,"use="$3">";else  print"\t<username>"$2"</username>\n""\t<hostname>"$3"</hostname>\n""\t<usedate>"$4"</usedate>\n""\t<usetime>"$5"</usetime>"}END{print"</featrue>"}' f.txt

复制代码

执行结果：

1. <featrue name=gf_welledit_bkz total=100 use=0>
   
2. </featrue>
   
3. <featrue name=gf_runtime total=500 use=16>
   
4.         <username>bsy_zc</username>
   
5.         <hostname>hp1083</hostname>
   
6.         <usedate>6/2</usedate>
   
7.         <usetime>8:09</usetime>
   
8.         <username>dbcsq</username>
   
9.         <hostname>hp1012</hostname>
   
10.         <usedate>6/2</usedate>
    
11.         <usetime>9:06</usetime>
    
12.         <username>dblbj</username>
    
13.         <hostname>hp1011</hostname>
    
14.         <usedate>6/2</usedate>
    
15.         <usetime>8:01</usetime>
    
16.         <username>dbllj</username>
    
17.         <hostname>hp1012</hostname>
    
18.         <usedate>6/2</usedate>
    
19.         <usetime>8:15</usetime>
    
20.         <username>dblxh</username>
    
21.         <hostname>hp1010</hostname>
    
22.         <usedate>6/2</usedate>
    
23.         <usetime>11:06</usetime>
    
24.         <username>dblxx</username>
    
25.         <hostname>hp1012</hostname>
    
26.         <usedate>6/2</usedate>
    
27.         <usetime>8:52</usetime>
    
28.         <username>dbly</username>
    
29.         <hostname>hp2036</hostname>
    
30.         <usedate>6/2</usedate>
    
31.         <usetime>10:32</usetime>
    
32.         <username>dbwjl</username>
    
33.         <hostname>hp1012</hostname>
    
34.         <usedate>6/2</usedate>
    
35.         <usetime>8:21</usetime>
    
36.         <username>dbxj</username>
    
37.         <hostname>hp1011</hostname>
    
38.         <usedate>6/2</usedate>
    
39.         <usetime>8:30</usetime>
    
40.         <username>dbyhx</username>
    
41.         <hostname>hp1012</hostname>
    
42.         <usedate>6/2</usedate>
    
43.         <usetime>8:50</usetime>
    
44.         <username>dbzlh</username>
    
45.         <hostname>hp1012</hostname>
    
46.         <usedate>6/2</usedate>
    
47.         <usetime>10:02</usetime>
    
48.         <username>gf43user</username>
    
49.         <hostname>sjkgeoframe</hostname>
    
50.         <usedate>6/2</usedate>
    
51.         <usetime>8:18</usetime>
    
52.         <username>glr_zg</username>
    
53.         <hostname>hp1014</hostname>
    
54.         <usedate>6/2</usedate>
    
55.         <usetime>8:42</usetime>
    
56.         <username>hmmyg</username>
    
57.         <hostname>hp1017</hostname>
    
58.         <usedate>6/1</usedate>
    
59.         <usetime>8:44</usetime>
    
60.         <username>hmrrj</username>
    
61.         <hostname>hp1078</hostname>
    
62.         <usedate>6/2</usedate>
    
63.         <usetime>8:42</usetime>
    
64. </featrue>
    

复制代码

[ 本帖最后由 lucash 于 2009-6-3 19:18 编辑 ]

springwind426

不知为什么要把 gf_basemap_plus 跳过去

1. 
   
2. perl -lane '
   
3. if($F[0] eq "gf_basemap_plus"){;}
   
4. elsif(!$a){$s=sprintf("<featrue name=%s total=%d use=%d>",$F[0],$F[1],$F[2]);}
   
5. elsif("$a" ne "$F[0]"){print "$s\n</featrue>";$s=sprintf("<featrue name=%s total=%d use=%d>",$F[0],$F[1],$F[2]);}
   
6. else{$s=sprintf "$s\n\t<username>%s</username>\n\t<hostname>%s</hostname>\n\t<usedate>%s</usedate>\n\t<usetime>%s</usetime>",$F[1],$F[2],$F[3],$F[4];}
   
7. $a=$F[0];
   
8. END{print "$s\n</featrue>";}
   
9. ' 数据文件
   

复制代码

blackold

应该是拉下了：

1. awk 'NF==3{if(NR!=1) print "</feature>"; print "<feature name="$1" total="$2" use="$3">"; next } NF==5{ print "\t<username>"$2"</username>\n\t<hostname>"$3"</hostname>\n\t<usedate>"$4"</usedate>\n\t<usetime>"$5"</usetime>" } END{ if(NF==5) print "</feature>" }' urfile

复制代码

yingweixu

感觉做出来也没有多大的实用性～

古道西风

原帖由 lucash 于 2009-6-3 18:54 发表
格式化后的结果里的第三行那个use＝49，这个49怎么来的阿？原文里没有阿 ？

写错了,就是上面的use,都是15

古道西风

原帖由 lucash 于 2009-6-3 19:12 发表
如果就只有这一段的话：
awk '/gf_welledit/{print"\n"};/runtime/{if ($5=="") print"";else  print"\t"$2"\n""\t"$3"\n""\t"$4"\n""\t"$5""}END{print""}' f.txt
执行结果：



        bsy_zc
      ...

不只这一段,很多,我只是截取了一部分

lucash

原帖由 古道西风 于 2009-6-4 08:08 发表

不只这一段,很多,我只是截取了一部分

昨天晚上就只有那一点，早点贴出来，把特点出来