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:
image

And then concatenate(), the nth(1) and nth(2) portions:

Regards,
Piet

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