Subfield Dynamically

[#1]

Hi

I have a field I would like to use a subfield function to select everything that comes after the first delimiter.

e.g 0987 Sugar Farm

In this case, I only want to get "Sugar Farm" using a dynamic function to accommodate records with more than 4 characters before the first delimiter and records that has more or less than two words after the first delimiter.

How can I do this?

[MarcoWedel · Accepted solution]

=Mid('0987 Sugar Farm', Index('0987 Sugar Farm',' ')+1)

[#3]

Thanks Marco! You are always helpful.

[MarcoWedel]

Glad it helped.

have a nice day

regards

Marco