Sean's version seams to work with the data shown, but if the field is a larger field it doesn't always get the correct results. I used a CASE statement to try and get the correct value. I've included the sample code below. I'm not saying it is 100% correct, but a little closer at least.

For some reason it doesn't like it when I include the SQL.

I had to include it as a text file.