Norse Technologies Knowledge Base Free Knowledge Articles

How to Use Microsoft Excel to Trim All Characters To The Right Of The First Occurrence A Specific Character:

This is a handy technique to trim all content in a cell that appears to the right of a particular character. For instance, to delete all content to the right of the first left parenthesis in the A1 cell:

=LEFT(A1|FIND(“(“|A1)-1)

Replace the character in the double quotes witht the character that is to be found and trimmed out along with all text to the right of it.

To trim all text to the right of, but not including the character, remove the -1 from the formula equation.

Posted under Uncategorized

I had a problem pasting text into a rich text editor using Firefox 3.0 on Windows Vista. I found a way to allow it to work.

This may help, however I’m not sure about the security implications involved in changing this setting:

Open a new tab, and go the URL “about:config”
Find the setting “noscript.allowClipboard” and set it to “true”

This worked for me, hopefully it helps for you.

( I posted this originally at http://forums.mozillazine.org/viewtopic.php?f=38&t=624240&p=5356385#p5356385 )

Posted under Browsers

Ran across this installing Red Hat’s free Linux distribution Fedora Core 9 code named Suplhur. Installed totally vanilla install with the GUI anaconda front end. The box sees the NIC, and can ping within the local subnet of the LAN network, but can’t ping out. BTW, it holds a static IP on the network interface card (NIC). Gets the error:

connect: Network is unreachable error

We need to set a default route. Here’s how:

Looked in /etc/sysconfig/network-scripts for the file route-eth0 but it wasn’t there.

Using vi (you can use whichever text editor you prefer) I created that file route-eth0, and put in this one line:

defult via 192.168.0.1

(note: 192.168.0.1 is the LAN IP address of my router. Your router IP address may differ. So you should put in whatever the IP addres of your router is, instead. Most Netgear routers and Qwest DSL boradband modems use 192.168.0.1 and Linksys uses 192.168.1.1 and Belkin uses 192.168.2.1 just to name some common ones.)

Then a simple task of restarting the network and testing:

# service network restart

# ping yahoo.com

Success!

Also, I found that the ethernet adapters weren’t starting automatically. Using the GUI taskbar/ Start Menu, I went into System Administration, then into Services, and enabled the “network” service. Then change runlevel to 3. Ping works so eth0 is up, and that happened at the runlevel change. Change to runlevel 5, test, and… yeppers, it works.

Posted under Freeware, Linux, Network

The CSS property “float”, when applied to an image will cause that image to -float- over to the left or right side of the conatiner they are within. The text flows around the image as you see in magazines and newspapers.

A simple addition to your stylesheet:

img.floatLeft {
float: left;
margin: 4px;
}
img.floatRight {
float: right;
margin: 4px;
}

Then, set the img tag to use the class:

<img class="floatRight">...

Viola!

Posted under CSS, WebDev