ParsingText from QuickBooks Customer/Job List

[skaterbase]

I'm trying to learn how to parse text from a field that looks like this:

Customer:Subcustomer:Job

or

MTV Networks:Betty Jones:Real World Episode 1

How can I get each piece of this string into its own field?

Thanks for any pointers!

[-Queue-]

Middle( ":" & text & ":", Position( ":" & text & ":", ":", 0, x ) + 1, Position( ":" & text & ":", ":", 0, x + 1 ) - Position( ":" & text & ":", ":", 0, x ) - 1 )

where 'x' is the ordinal group for which you are parsing, i.e. when x = 2, the former record returns 'Subcustomer' and the latter returns 'Betty Jones'.

[skaterbase]

Thanks so much! This is exactly what I needed. And perhaps someday I'll understand it...