Another option or variation on the solutions offered would be to parse the string using CLR ?

We have gone down this route before and, without digging up the benchmarking(sorry), we...