Excel – Remove All Text After Specified Character

Posted: June 10th, 2011 | Author: | Filed under: excel, windows | 1 Comment »

This excel function searches the cell ‘V22′ for the ‘greater than’ character. If it is found then it will remove that character and everything after it. If not found then it will copy V22′s value.

=IF(ISNUMBER(SEARCH(">" , V22)) , LEFT(V22,FIND(">",V22,1) - 1) , V22)

Create Global Function In Magento

Posted: June 9th, 2011 | Author: | Filed under: magento, web | Tags: | 2 Comments »

This code will allow you to add a function that can be called from anywhere within Magento. It extends the helper class

1) Create a file named ‘Mycode.xml’ and copy it to app/etc/modules/ – it should look like this:

<?xml version="1.0"?>
<config>
    <modules>
		<Mycode_Function>
			<active>true</active>
			<codePool>local</codePool>
		</Mycode_Function>
    </modules>
</config>

2) Create the directory
app/code/local/Mycode/Function/etc
and then create a file named ‘config.xml’
In it copy:

<?xml version="1.0"?>
<config>
 
    <modules>
        <Mycode_Function>
            <version>1.0.0</version>
        </Mycode_Function>
    </modules>
 
    <global>
 
        <helpers>
            <function>
                <class>Mycode_Function_Helper</class>
            </function>
        </helpers> 
 
    </global>
 
</config>

3) Create the directory
app/code/local/Mycode/Function/Helper
and then create a file named ‘Data.php’
In it copy:

<?php
 
class Mycode_Function_Helper_Data extends Mage_Core_Helper_Abstract
{
 
	public function test(){
 
	return 'works';
 
	}
 
}

You can now call this function like so

		<?php 
 
		 echo Mage::helper('function')->test();
 
		 ?>

Update To Drupal 7.2 The Easy Way (SSH)

Posted: May 29th, 2011 | Author: | Filed under: drupal, web | Tags: , , | 1 Comment »

After backing everything up…

# get the upgrade
wget http://ftp.drupal.org/files/projects/drupal-7.2.tar.gz
 
# uncompress it
tar xfzv drupal-7.2.tar.gz
 
# copy all files to my document root
cp -r drupal-7.2/. /www/.

found here


Blank Html Template – Strict dtd

Posted: May 13th, 2011 | Author: | Filed under: html, web | No Comments »
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
 
<head>
 
<title>Blank Strict Template</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="description" content="">
<meta name="keywords" content="">
 
<script type="text/javascript">
</script>
 
<style type="text/css">
</style>
 
</head>
 
<body>
	<div>
	     <p>blank template</p>
	</div>
</body>
 
</html>

Download zipped html file