Thread: To find and replace in text file

Hi,

I need help on following problem.

I have a text file something like below...

I have to replace ":" "." "space" with , using either sed or awk can some one help me on this...

Thanks in Advance..

=====================================

21:2007.11.13 00:38:13:399 Env/TP-Processor8:INFO:CORE BEGIN Session=9C3ACA5E8BE596EC39D2761AC66EC9E2.bstby1 Active Sessions: 776
29:2007.11.13 00:38:13:918 Env/TP-Processor6:INFO:CORE BEGIN Session=3152E297D96912192109B8F9BEBB1446.bstby1 Active Sessions: 777
88:2007.11.13 00:38:15:832 Env/TP-Processor2:INFO:CORE BEGIN Session=50D731F3EE59D3595A25140F166E9F93.bstby1 Active Sessions: 767
116:2007.11.13 00:38:16:793 Env/TP-Processor7:INFO:CORE BEGIN Session=B7977F67D06591A78AA2F290DBCE6F2C.bstby1 Active Sessions: 768
144:2007.11.13 00:38:19:219 Env/TP-Processor12:INFO:CORE BEGIN Session=19C3468F71BC6B2BEA03C3F2D4F74E44.bstby1 Active Sessions: 769
172:2007.11.13 00:38:21:930 Env/TP-Processor2:INFO:CORE BEGIN Session=13DA23B1E5787E4E07B3098A17CAFBAC.bstby1 Active Sessions: 770

=============================================

Code:

echo '21:2007.11.13 00:38:13:399 Env/TP-Processor8:INFO:CORE BEGIN Session=9C3ACA5E8BE596EC39D2761AC66EC9E2.bstby1 Active Sessions: 776' | sed -e "s/:/./g"

Thanks a lot Vivek... It worked perfectly

i got the below answer but if i m hving tht txt in file..where is the place int the script to mention my filename sam.txt
sam.txt contains
21:2007.11.13 00:38:13:399 Env/TP-Processor8:INFO:CORE BEGIN Session=9C3ACA5E8BE596EC39D2761AC66EC9E2.bstby1 Active Sessions: 776
29:2007.11.13 00:38:13:918 Env/TP-Processor6:INFO:CORE BEGIN Session=3152E297D96912192109B8F9BEBB1446.bstby1 Active Sessions: 777
88:2007.11.13 00:38:15:832 Env/TP-Processor2:INFO:CORE BEGIN Session=50D731F3EE59D3595A25140F166E9F93.bstby1 Active Sessions: 767
116:2007.11.13 00:38:16:793 Env/TP-Processor7:INFO:CORE BEGIN Session=B7977F67D06591A78AA2F290DBCE6F2C.bstby1 Active Sessions: 768
144:2007.11.13 00:38:19:219 Env/TP-Processor12:INFO:CORE BEGIN Session=19C3468F71BC6B2BEA03C3F2D4F74E44.bstby1 Active Sessions: 769
172:2007.11.13 00:38:21:930 Env/TP-Processor2:INFO:CORE BEGIN Session=13DA23B1E5787E4E07B3098A17CAFBAC.bstby1 Active Sessions: 770

Originally Posted by nashtech

Hi,

I need help on following problem.

I have a text file something like below...

I have to replace ":" "." "space" with , using either sed or awk can some one help me on this...

Thanks in Advance..

=====================================

21:2007.11.13 00:38:13:399 Env/TP-Processor8:INFO:CORE BEGIN Session=9C3ACA5E8BE596EC39D2761AC66EC9E2.bstby1 Active Sessions: 776
29:2007.11.13 00:38:13:918 Env/TP-Processor6:INFO:CORE BEGIN Session=3152E297D96912192109B8F9BEBB1446.bstby1 Active Sessions: 777
88:2007.11.13 00:38:15:832 Env/TP-Processor2:INFO:CORE BEGIN Session=50D731F3EE59D3595A25140F166E9F93.bstby1 Active Sessions: 767
116:2007.11.13 00:38:16:793 Env/TP-Processor7:INFO:CORE BEGIN Session=B7977F67D06591A78AA2F290DBCE6F2C.bstby1 Active Sessions: 768
144:2007.11.13 00:38:19:219 Env/TP-Processor12:INFO:CORE BEGIN Session=19C3468F71BC6B2BEA03C3F2D4F74E44.bstby1 Active Sessions: 769
172:2007.11.13 00:38:21:930 Env/TP-Processor2:INFO:CORE BEGIN Session=13DA23B1E5787E4E07B3098A17CAFBAC.bstby1 Active Sessions: 770

=============================================

Open file in vi editor and do this :%s/:/.g

Originally Posted by pooppp

i got the below answer but if i m hving tht txt in file..where is the place int the script to mention my filename sam.txt
sam.txt contains
21:2007.11.13 00:38:13:399 Env/TP-Processor8:INFO:CORE BEGIN Session=9C3ACA5E8BE596EC39D2761AC66EC9E2.bstby1 Active Sessions: 776
29:2007.11.13 00:38:13:918 Env/TP-Processor6:INFO:CORE BEGIN Session=3152E297D96912192109B8F9BEBB1446.bstby1 Active Sessions: 777
88:2007.11.13 00:38:15:832 Env/TP-Processor2:INFO:CORE BEGIN Session=50D731F3EE59D3595A25140F166E9F93.bstby1 Active Sessions: 767
116:2007.11.13 00:38:16:793 Env/TP-Processor7:INFO:CORE BEGIN Session=B7977F67D06591A78AA2F290DBCE6F2C.bstby1 Active Sessions: 768
144:2007.11.13 00:38:19:219 Env/TP-Processor12:INFO:CORE BEGIN Session=19C3468F71BC6B2BEA03C3F2D4F74E44.bstby1 Active Sessions: 769
172:2007.11.13 00:38:21:930 Env/TP-Processor2:INFO:CORE BEGIN Session=13DA23B1E5787E4E07B3098A17CAFBAC.bstby1 Active Sessions: 770

you can just use the shell

Code:

while read -r line
do
    echo ${line//[:. ]/,}
done <"file" > new
mv new file

or you can use awk

Code:

awk '{gsub(/[:, ]/,","}1' file

I think this will help you.

sed -i 's/[.,:, ]/ /g' filename

----
Suku
techtrunch.com

Hello,

I'd like to do something like above, but instead of searching a specific text I'd like to use the variable a. How is the syntax in the second awk line for $a?


I tryed this, but nothing works:

HTML Code:

a=`awk '{if ($1 == "###" && $2 == "END" ) { getline; print } } ' networking`

b="mimi"
awk -v var=$b '{ gsub(/[$a]/,var,$0); print }' networking > bla[/QUOTE]awk -v var=$b '{ gsub(/[$a]/,var,$0); print }' networking > bla

HTML Code:

awk -v var=$b '{ gsub(/$a/,var,$0); print }' networking > bla

HTML Code:

awk -v var=$b '{ gsub($a,var,$0); print }' networking > bla

Or maybe in other words: in the /etc/init.d/networking file I want to write 3 lines below the text "### END INIT INFO".

I should search for the line containing ### END INIT INFO and then write something below this line.
Please help!
edubidu

Originally Posted by edubidu

Or maybe in other words: in the /etc/init.d/networking file I want to write 3 lines below the text "### END INIT INFO".

I should search for the line containing ### END INIT INFO and then write something below this line.
Please help!
edubidu

Try sed with append command (a )

Code:

 sed '
/### END INIT INFO/ a\
One\
Two\
Three
' /etc/init.d/networking

OR save to other file:

Code:

sed '
/### END INIT INFO/ a\
One\
Two\
Three
' /etc/init.d/networking  > /tmp/output

Or pass sed -i option to update the file itself.

Originally Posted by nixcraft

Try sed with append command (a )

Code:

 sed '
/### END INIT INFO/ a\
One\
Two\
Three
' /etc/init.d/networking

OR save to other file:

Code:

sed '
/### END INIT INFO/ a\
One\
Two\
Three
' /etc/init.d/networking  > /tmp/output

Or pass sed -i option to update the file itself.

cool, this works! THANK YOU!