replace word with using "sed" not work...


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting replace word with using "sed" not work...
# 15  
Old 02-28-2007
# 16  
Old 02-28-2007
Quote:
Originally Posted by matrixmadhan
sorry..yes. but I just open need issue and for other guy to search the topic easier..
# 17  
Old 02-28-2007
Quote:
Originally Posted by happyv
but..the sed command...how can you identify <number>? because of the file not just <number> field...it also contain <serial no>, etc..
Ah, you didn't provide all the information.

Code:
# cat file
<Number>11 20 03 22 23 21 91 00 F0</Number>
<Number>12 20 03 20 99 21 91 20 F0</Number>
<Serial>12 20 03 20 99 21 91 20 F0</Serial>
<Number>10 21 03 21 78 21 92 27 F0</Number>
# sed -e "/^<Number/s/ //g" -e "/^<Number/s/\([0-9][0-9]\)./\1/" -e "/^<Number/s/\([0-9][0-9]\)/\1 /g" -e "/^<Number/s/0</</" file
<Number>11 00 32 22 32 19 10 0F</Number>
<Number>12 00 32 09 92 19 12 0F</Number>
<Serial>12 20 03 20 99 21 91 20 F0</Serial>
<Number>10 10 32 17 82 19 22 7F</Number>

# 18  
Old 02-28-2007
Quote:
Originally Posted by sb008
Ah, you didn't provide all the information.

Code:
# cat file
<Number>11 20 03 22 23 21 91 00 F0</Number>
<Number>12 20 03 20 99 21 91 20 F0</Number>
<Serial>12 20 03 20 99 21 91 20 F0</Serial>
<Number>10 21 03 21 78 21 92 27 F0</Number>
# sed -e "/^<Number/s/ //g" -e "/^<Number/s/\([0-9][0-9]\)./\1/" -e "/^<Number/s/\([0-9][0-9]\)/\1 /g" -e "/^<Number/s/0</</" file
<Number>11 00 32 22 32 19 10 0F</Number>
<Number>12 00 32 09 92 19 12 0F</Number>
<Serial>12 20 03 20 99 21 91 20 F0</Serial>
<Number>10 10 32 17 82 19 22 7F</Number>


its look like still have some problem.. because of...your command read <Number is missing ">"..
# 19  
Old 02-28-2007
Quote:
Originally Posted by happyv
its look like still have some problem.. because of...your command read <Number is missing ">"..
It doesn't matter the ">" is missing unless there are other Tags which start with "<Number".

But what stops you to add the extra ">" if it's needed.

You know what the input file looks like.

Either provide all details about the input file or use some of your own creativity. Based on the examples you should be able to correct it to your needs.
# 20  
Old 02-28-2007
Quote:
Originally Posted by sb008
It doesn't matter the ">" is missing unless there are other Tags which start with "<Number".

But what stops you to add the extra ">" if it's needed.

You know what the input file looks like.

Either provide all details about the input file or use some of your own creativity. Based on the examples you should be able to correct it to your needs.
yes..you're right. please check the below my.xml file. In front of the first "<Number>" have around 6 ~9 space (because of i will convert into another format after fixed the problem).

As mentioned before, I need to delete 3nd number and move one forward, then delete last digit. so that the list one will be like "7F</Number>" for the first record

<Number>11 48 79 74 71 47 97 F0</Number>
<Number>11 48 79 67 64 76 63 F0</Number>
<Number>11 48 78 91 39 26 41 F0</Number>
<Number>11 48 78 82 43 96 22 F0</Number>
<Number>11 50 79 56 22 16 77 F0</Number>
<Number>11 48 79 56 22 16 77 F0</Number>
<Number>11 48 77 15 54 00 75 F0</Number>
<Number>11 48 79 56 22 16 77 F0</Number>
<Number>11 48 78 91 56 76 39 F0</Number>
<Number>11 33 06 14 24 36 26 80 F0</Number>
<Number>11 48 06 14 24 36 26 80 F0</Number>
<Number>11 48 78 82 43 96 22 F0</Number>
<Number>11 48 78 91 39 26 41 F0</Number>
<Number>11 48 79 29 33 85 94 F0</Number>
<Number>11 20 79 46 93 73 87 F0</Number>
<Number>11 48 79 67 64 76 63 F0</Number>
<Number>11 21 79 74 71 47 97 F0</Number>
<Number>11 48 79 29 33 85 94 F0</Number>
<Number>11 00 79 67 64 76 63 F0</Number>
<Number>11 48 06 14 24 36 26 80 F0</Number>
<Number>11 99 79 69 08 44 09 F0</Number>
<Number>11 48 08 52 91 83 55 71 F0</Number>
<Number>11 48 78 41 65 21 82 F0</Number>
<Number>11 87 77 90 77 53 88 F0</Number>
<Number>11 48 06 14 24 36 26 80 F0</Number>
<Number>11 77 77 02 63 52 01 F0</Number>
<Number>11 12 79 69 08 44 09 F0</Number>
<Number>11 13 79 71 22 87 43 F0</Number>
<Number>11 98 78 91 48 73 39 F0</Number>
<Number>11 97 78 91 56 79 38 F0</Number>
<Number>11 94 79 66 20 57 47 F0</Number>
<Number>11 33 77 25 99 67 03 F0</Number>
# 21  
Old 02-28-2007
Modifying sb008's solution fetch only Numbers

Code:
sed -e "/<Number>/ s/ //g;s/\([0-9][0-9]\)./\1/;s/\([0-9][0-9]\)/\1 /g;s/0</</" file

Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add the word "prefix" to beginning of line using sed

SUSE linux bash shell this works test -d /tmpp && echo "directory exists" || echo "directory doesn't exists" |sed -e "s/^/prefix /" prefix directory doesn't exists but why doesn't this work? test -d /tmp && echo "directory exists" || echo "directory doesn't exists" |sed -e... (3 Replies)
Discussion started by: snoman1
3 Replies

2. Shell Programming and Scripting

How do i replace a word ending with "key" using awk excpet for one word?

echo {mbr_key,grp_key,dep_key,abc,xyz,aaa,ccc} | awk 'gsub(/^|abc,|$/,"") {print}' Required output {grp_key,xyz,aaa,ccc} (5 Replies)
Discussion started by: 100bees
5 Replies

3. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

4. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

5. Shell Programming and Scripting

Interesting question - Search and replace the word after sign "="

Hi Guys, Req your help in searching and replacing the word that comes after equals(=) symbol I would like to replace the sting in bold with a string in variable. d=ABCDF8C44C22 # grep -i NIM_MASTERID ${_NIMINFO} export NIM_MASTERID=00CDF8C44C00 I'm looking to replace any word that... (4 Replies)
Discussion started by: ajilesh
4 Replies

6. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

7. Shell Programming and Scripting

Extract Part of a "Word", using AWK or SED????

I have been lurking on this forum for some time now and appreciate Everyone's help. I need to find a way to get the SystemID from this XML file. The file is much larger than just this one line but I can grep and get this line Printed. But really just need the "systemid". <test123: prefintem... (9 Replies)
Discussion started by: elbombillo
9 Replies

8. Shell Programming and Scripting

Can "sed" substitute word on a specific line?

Hello experts, I know line number of the word I want to replace. Can "sed" substitute word on a specific line? As well, can sed substitute words inside a specific patten. ex. <word>lalala</word> #replace anything between <word> and </word> minifish (2 Replies)
Discussion started by: minifish
2 Replies
Login or Register to Ask a Question