Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I worked it out...
Left(SubField([Key Join],'ML:',2),36)