文本處理求助-空格變下劃線

bikkuri

大家好！
我有一個(gè)問題向大家請(qǐng)教。
有以下一段文本。

1. |---o-[2016-02-17 11:01:03] node115 [135.240.146.115]: 7705 SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.54%)
   
2. |-o---[2016-02-17 11:01:07] node116 [135.240.146.116]: 7705 SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  4.95%)
   
3. |---o-[2016-02-17 11:01:11] node117 [135.240.146.117]: 7705 SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  7.55%)
   
4. |-o---[2016-02-17 11:01:15] node118 [135.240.146.118]: 7705 SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  7.96%)
   
5. |---o-[2016-02-17 11:01:19] node119 [135.240.146.119]: 7210 SAS-D 6F4T ETR-1 running TiMOS-B-7.0.R7     (CPU Usage:  3.48%)
   
6. |-o---[2016-02-17 11:01:24] node120 [135.240.146.120]: 7210 SAS-D 6F4T ETR-1 running TiMOS-B-7.0.R6     (CPU Usage:  6.78%)
   

復(fù)制代碼

希望把第56-76字節(jié)之間的部分中間的空格改成下劃線_，即處理后變成以下文本。

1. |---o-[2016-02-17 11:01:03] node115 [135.240.146.115]: 7705_SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.54%)
   
2. |-o---[2016-02-17 11:01:07] node116 [135.240.146.116]: 7705_SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  4.95%)
   
3. |---o-[2016-02-17 11:01:11] node117 [135.240.146.117]: 7705_SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  7.55%)
   
4. |-o---[2016-02-17 11:01:15] node118 [135.240.146.118]: 7705_SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  7.96%)
   
5. |---o-[2016-02-17 11:01:19] node119 [135.240.146.119]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R7     (CPU Usage:  3.48%)
   
6. |-o---[2016-02-17 11:01:24] node120 [135.240.146.120]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R6     (CPU Usage:  6.78%)
   

復(fù)制代碼

謝謝大家！

haooooaaa

1. awk '{s=$5;for(i=1;i<=NF-10;i++)s=s" "$(5+i);m=s;gsub(" ","*",s);sub(m,s)}1' file

復(fù)制代碼

elu_ligao

1. sed 's/\(: [0-9]\{4\}\) \([^ ]\{5\}\) \([^ ]\{4\}\) \([^ ]\{5\}\)/\1_\2_\3_\4/' file

復(fù)制代碼

haooooaaa

1. awk '{while(NF>10)sub($5" ",$5"_")}1' file
   

復(fù)制代碼

bikkuri

非常感謝！
您的命令可以將空格正確地轉(zhuǎn)換成下劃線。
但是我試了一下把空格轉(zhuǎn)換成星號(hào)*，卻失敗了。

1. [root@hp8:~]# awk '{while(NF>10)sub($5" ",$5"_")}1' lv
   
2. |---o-[2016-02-17 12:01:06] node115 [135.240.146.115]: 7705_SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.56%)
   
3. |-o---[2016-02-17 12:01:10] node116 [135.240.146.116]: 7705_SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  3.58%)
   
4. |---o-[2016-02-17 12:01:14] node117 [135.240.146.117]: 7705_SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  3.47%)
   
5. |-o---[2016-02-17 12:01:18] node118 [135.240.146.118]: 7705_SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  3.49%)
   
6. |---o-[2016-02-17 12:01:22] node119 [135.240.146.119]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R7     (CPU Usage:  4.82%)
   
7. |-o---[2016-02-17 12:01:27] node120 [135.240.146.120]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R6     (CPU Usage:  3.47%)
   
8. [root@hp8:~]# awk '{while(NF>10)sub($5" ",$5"*")}1' lv
   
9. |---o-[2016-02-17 12:01:06] node115 [135.240.146.115]: 7705*SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.56%)
   
10. |-o---[2016-02-17 12:01:10] node116 [135.240.146.116]: 7705*SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  3.58%)
    
11. |---o-[2016-02-17 12:01:14] node117 [135.240.146.117]: 7705*SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  3.47%)
    
12. |-o---[2016-02-17 12:01:18] node118 [135.240.146.118]: 7705*SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  3.49%)
    
13. ^C
    
14. [root@hp8:~]# awk '{while(NF>10)sub($5" ",$5"\*")}1' lv
    
15. awk: warning: escape sequence `\*' treated as plain `*'
    
16. |---o-[2016-02-17 12:01:06] node115 [135.240.146.115]: 7705*SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.56%)
    
17. |-o---[2016-02-17 12:01:10] node116 [135.240.146.116]: 7705*SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  3.58%)
    
18. |---o-[2016-02-17 12:01:14] node117 [135.240.146.117]: 7705*SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  3.47%)
    
19. |-o---[2016-02-17 12:01:18] node118 [135.240.146.118]: 7705*SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  3.49%)
    
20. ^C
    
21. [root@hp8:~]#
    

復(fù)制代碼

第1-4行的空格可以正確地轉(zhuǎn)換成星號(hào)，但是第5行就不行了。
請(qǐng)問這是為什么呢？
回復(fù) 3# haooooaaa


   

bikkuri

謝謝您的回復(fù)。
但是您的命令只能轉(zhuǎn)換第5-6行，第1-4行沒有轉(zhuǎn)換。

1. [root@hp8:~]# sed 's/\(: [0-9]\{4\}\) \([^ ]\{5\}\) \([^ ]\{4\}\) \([^ ]\{5\}\)/\1_\2_\3_\4/' lv
   
2. |---o-[2016-02-17 12:01:06] node115 [135.240.146.115]: 7705 SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.56%)
   
3. |-o---[2016-02-17 12:01:10] node116 [135.240.146.116]: 7705 SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  3.58%)
   
4. |---o-[2016-02-17 12:01:14] node117 [135.240.146.117]: 7705 SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  3.47%)
   
5. |-o---[2016-02-17 12:01:18] node118 [135.240.146.118]: 7705 SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  3.49%)
   
6. |---o-[2016-02-17 12:01:22] node119 [135.240.146.119]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R7     (CPU Usage:  4.82%)
   
7. |-o---[2016-02-17 12:01:27] node120 [135.240.146.120]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R6     (CPU Usage:  3.47%)
   
8. [root@hp8:~]#

復(fù)制代碼

回復(fù) 2# elu_ligao


   

jason680

回復(fù) 1# bikkuri

WYTIWYC(What You Think Is What You Code)

希望把第56-76字節(jié)之間的部分中間的空格改成下劃線_，即處理后變成以下文本。

1. using RE function(gensub) to change space to underline directly
$ awk -vs=56 -ve=76 'function get(st,end){return(end==""?substr($0,st):substr($0,st,end-st+1))}function sp2ud(str){return(gensub(/ ([^ ])/,"_\\1","g",str))}{h=get(1,s-1);b=get(s,e);t=get(e+1,"");print h sp2ud(b) t}' FILE
|---o-[2016-02-17 11:01:03] node115 [135.240.146.115]: 7705_SAR-F            running TiMOS-B-6.0.R4     (CPU Usage:  3.54%)
|-o---[2016-02-17 11:01:07] node116 [135.240.146.116]: 7705_SAR-F            running TiMOS-B-6.1.R2     (CPU Usage:  4.95%)
|---o-[2016-02-17 11:01:11] node117 [135.240.146.117]: 7705_SAR-M            running TiMOS-B-6.1.R7     (CPU Usage:  7.55%)
|-o---[2016-02-17 11:01:15] node118 [135.240.146.118]: 7705_SAR-M            running TiMOS-B-5.0.R9     (CPU Usage:  7.96%)
|---o-[2016-02-17 11:01:19] node119 [135.240.146.119]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R7     (CPU Usage:  3.48%)
|-o---[2016-02-17 11:01:24] node120 [135.240.146.120]: 7210_SAS-D_6F4T_ETR-1 running TiMOS-B-7.0.R6     (CPU Usage:  6.78%)


   

moperyblue

[code][/code]

ly5066113

回復(fù) 1# bikkuri


try:

1. awk -vFIELDWIDTHS='55 21 1000' -vOFS= '$2=gensub(/([^ ]) ([^ ])/,"\\1_\\2","g",$2)' file

復(fù)制代碼

ly5066113

回復(fù) 1# bikkuri


try:

1. sed -r ':a;s/^(.{55})(.{0,18})([^ ]) ([^ ])/\1\2\3_\4/;ta' file

復(fù)制代碼