I have a report which extracts an already-concatenated string of around 9 database fields, each separated by a colon. I've been tasked with separating this string out into the original fields using a formula, but I'm struggling!

Example Field

{01/01/2012: Example: 130.00: 240.00: 100.00: Y: N: Y: Y}

Example (desired) Output

{01/01/2012} {Example} {130.00} {240.00} {100.00} {Y} {N} {Y} {Y}

Any assistance with a formula which would achieve the above would be much appreciated!

Thanks - that works perfectly