Altering Data Output

Hi,
use str_replace(), substr() and strpos() PHP functions to find and return part of string.

Here are some examples:

http://php.net/manual/en/function.substr.php

http://php.net/manual/en/function.str-replace.php

http://php.net/manual/en/function.strpos.php

Jane, I am clueless when it comes to php code which is why I bought phprunner. If possible, could you show me how with the code? This is what I've tried.
[codebox]update table set column = concat(substr(column,1,8),'(',substr(column,9,4),')')[/codebox]
And I tried this
[codebox]<?

$src = "09.2008 22.0 (102)";

$pos = strpos($src, " (");

$new = substr($src, 0, $pos-2);

$pos = strpos($new, " ");

$len = strlen($new);

$new = substr($new, 0, $pos+1)."(".substr($new, $pos+1).")";

?> [/codebox]
But neither worked.

Anyone have an idea? This works with a straight php page but I don't know how to enter this into phprunner. Help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=30247&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' />
[codebox]<?php
$link = mysql_connect('localhost', 'dbase', 'password');

mysql_select_db('dbase');

$sql = 'select mytable';

$r = mysql_query($sql);

echo mysql_error();

$row = mysql_fetch_row($r);

echo $row[0];

echo '<br />';

echo preg_replace('/(\d{2}\.\d{4}) (\d+\.\d+) \(\d+\)/', '$1 ($2)', $row[0]);
?>[/codebox]

Hi,
try to use this code on the "View as" settings dialog --> Custom on the Visual Editor tab:

$value = preg_replace('/(\d{2}\.\d{4}) (\d+\.\d+) \(\d+\)/', '$1 ($2)', $value);