Hi all :)

I've got a string field (250chars long) which contains random notes written by multiple people. they all have their own shorthand, which doesn't help matters!

Anyways, it's possible that some records contain (1) "SS: 123456789" and/or "YN: ABCDEFGHIJKLMNOPQRSTTUVWXYZ SGYUB".

The SS details should be limited to nine numbers, but the YN section could take up the remaining 237chars. Having said that, it might only take up six; there's no way of knowing how much they'll type.

I want to be able to extract just the "123456789" and "ABCDEFGHIJKLMNOPQRSTTUVWXYZ SGYUB" parts of the field.

I tried using split({field}) and splitting by " ", but it insists the array is limited to [1].

If I split it using two spaces, it returns the entire note field.

Is there any way to find the start position of the YN field, figure out the length to the next space and then extract that section of the string?

Or does anyone know an easier way to do this?

Thanks (in advance :) )
-Q

Oh, excellent :)

Thanks!