aldin
New Member
- Joined
- Sep 23, 2005
- Messages
- 24
hi all,<HTML><HEAD><Script Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'>
</SPAN><CENTER><HR><FORM NAME='form1'><INPUT TYPE='Button' value='Please click this button to send the source to clipbord' onClick='CopyToClipBoard();'><INPUT TYPE='Button' value='View Source' onClick='ViewSource();'></FORM><FONT COLOR=#339966 SIZE=2> This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003</FONT><FONT COLOR=#339966 SIZE=2>Code mods by Ivan F Moala - 15th May 2003</FONT></HR></BODY></HTML>
this is my sheet im trying to change the column A w/c coil # to this format 0512639-401 its compose of more than 2000 rows. is there anyway that i can make easier, because im tired of draging the last 3 digit and change the color and turn in into bold.hope there is thx in advance.
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'>
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | coil# | Thickness | Width | Length | Weight | ||
| 2 | 0512639-401 | 230 | 1250 | 8600 | 19.500 | ||
| 3 | 0512639-402 | 230 | 1250 | 8600 | 19.490 | ||
| 4 | 0512639-404 | 230 | 1250 | 8600 | 19.510 | ||
| 5 | 0512639-304 | 230 | 1250 | 8600 | 19.510 | ||
| 6 | 0512639-403 | 230 | 1250 | 8600 | 19.470 | ||
| 7 | 0512640-302 | 230 | 1250 | 8600 | 19.590 | ||
| 8 | 0512640-401 | 230 | 1250 | 8600 | 19.510 | ||
| 9 | 0512640-301 | 230 | 1250 | 8600 | 19.550 | ||
| 10 | 0512640-304 | 230 | 1250 | 8600 | 19.590 | ||
| 11 | 0512640-404 | 230 | 1250 | 8600 | 19.320 | ||
| 12 | 0512640-303 | 230 | 1250 | 8600 | 19.510 | ||
| 13 | 0512640-403 | 230 | 1250 | 8600 | 19.410 | ||
| 14 | 0512640-305 | 230 | 1250 | 8600 | 19.560 | ||
| 15 | 0512640-402 | 230 | 1250 | 8600 | 19.500 | ||
| 16 | 0512649-301 | 230 | 1250 | 8600 | 19.600 | ||
| 17 | 0512650-403 | 230 | 1250 | 8600 | 19.420 | ||
| 18 | 0512654-201 | 230 | 1250 | 8600 | 19.490 | ||
| 19 | 0512654-104 | 230 | 1250 | 8600 | 19.520 | ||
| 20 | 0512654-203 | 230 | 1250 | 8600 | 19.530 | ||
| 21 | 0512654-101 | 230 | 1250 | 8600 | 19.490 | ||
| 22 | 0512654-103 | 230 | 1250 | 8600 | 19.520 | ||
| 23 | 0512654-102 | 230 | 1250 | 8600 | 19.510 | ||
| 24 | 0512654-202 | 230 | 1250 | 8600 | 19.490 | ||
| 25 | 0512660-101 | 230 | 1250 | 8600 | 19.490 | ||
| 26 | 0512660-104 | 230 | 1250 | 8600 | 19.490 | ||
| 27 | 0512660-204 | 230 | 1250 | 8600 | 19.460 | ||
| 28 | 0512660-103 | 230 | 1250 | 8600 | 19.540 | ||
| 29 | 0512660-102 | 230 | 1250 | 8600 | 19.460 | ||
| 30 | 0512660-201 | 230 | 1250 | 8600 | 19.490 | ||
| 31 | 0512661-201 | 230 | 1250 | 8600 | 19.440 | ||
| 32 | 0512661-102 | 230 | 1250 | 8600 | 19.580 | ||
Sheet3 | |||||||
this is my sheet im trying to change the column A w/c coil # to this format 0512639-401 its compose of more than 2000 rows. is there anyway that i can make easier, because im tired of draging the last 3 digit and change the color and turn in into bold.hope there is thx in advance.
