How can I return the first portion of a text field and stop at the second period?
Hi Chris,
You can use Split() with a period as delimiter:
And then concatenate(), the nth(1) and nth(2) portions:
Regards, Piet