How to Extract Certain Text from a String

[haymarketpaul]

I need to extract the 36 characters immediately following these three characters - ML:

What makes it tricky is the ML: bit may be at the beginning, somewhere in the middle or at the end.

Here's some sample data:-

C:422756ML:2aee1243-4c64-5f83-9826-b395675611a5

C:422767ML:b77fc68d-2944-5b70-ab90-f1a542cafc3eEF2:5426M:2337938

ML:0a3df3fe-62bf-4591-b4c1-3726f433a7e1

ML:ed961a43-e0d0-4fe1-b9a9-1448b28741adEF2:61511

U:4757022C:417992ML:ffe99a2a-abf9-46e1-9084-f42d8b195426EF2:167122M:203699

U:3786803D:2994ML:a3f669d9-d9fe-5fa3-81c0-72b4fe54b85fRYI:291EF2:45697

Any ideas much appreciated

[haymarketpaul · Accepted solution]

I worked it out...

Left(SubField([Key Join],'ML:',2),36)