DaveShaw.net

Assuming you have a spreadsheet with column A with header "Full Name" instead of "First name" and "Last name"

You can usually split these apart by searching for a space. Names with 3 parts or only 1 will not work and may require you to get a bit more fancy but this will work in most cases:

Formula for splitting out the First Name in OpenOffice

Find a space then take that many characters from the left minus 1 to remove the trailing space itself.

Formula for splitting out the Last Name in OpenOffice

If you've tried right clicking and dragging and dropping the item out but it just won't be removed from your Mac sidebar:

Hold the "Command" key
Drag and drop it from the sidebar
A cloud will appear
The item will disappear and be removed from your Mac sidebar.

Bothered me for a bit so i thought i'd share

enjoy

-Dave Shaw

According to the PHP Pear Send function manual:
http://pear.php.net/manual/en/package.mail.mail.send.php

You can send to and from a raw email address.
But how do you include the person's first and last name using the PHP Pear Send function?

From header format to include names

Dynamic email to header format

Play edit and export quicktime to any format

MPEG Streamclip is A great free editor and video player for mac osx.
Simply hit 'i' and 'o' to set in and out points then export 'command + e'

Download MPEG Streamclip

AVI Codec Support

Perian is another amazing bit of mac osx freeware.

Cisco VPN Client Error 51

Fix Cisco VPN by restarting CiscoVPN.kext

Open a terminal:
Applications -> Utilities -> Terminal

switch to your super user admin account and enter your password when promted

Next restart CiscoVPN.kect

Go to the Drupal Admin Status Reports page.

Admin > Status report > Cron maintenance tasks

Run the manual cron link

Click the link titled "You can run cron manually."
which should link to

For this site click here:
http://daveshaw.net/admin/logs/status/run-cron

Dave Shaw

lowercase

Its simple to make lowercase words string to lower strtolower() function

UPPERCASE

Its also simple to make UPPERCASE words with the string to upper strtoupper() function

Proper Nouns

So what if you want Mixed Case? Is there a proper() function like in open office? What about strtomixed() or strtoproper()? No!
You need the uppercase words function ucwords().

If you plan to have long text shown in an info window of your google maps you will need to allow your content to overflow.

This is not set using any special google API tricks.

Set your content to overflow using css

The CSS overflow property for your div should be set to auto or scroll.


#map-content {
padding: 20px;
margin: 0 auto;
border: none;
width: 300px;
Height: 400px;
overflow: auto;
}