It is probably easier to do it in php. Try adding this function to the page:
<?php
function first_name($name) {
$name = trim($name);
$last_name = (strpos($name, ' ') === false) ? '' : preg_replace('#.*\s([\w-]*)$#', '$1', $name);
$first_name = trim( preg_replace('#'.$last_name.'#', '', $name ) );
return $first_name;
}
?>
Then you can get the first name with something like:
<?php echo(first_name($Recordset->getColumnVal("fullNameColumn"))); ?>