Return first part of text up to the second period?

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:


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.