Return first part of text up to the second period?

1

How can I return the first portion of a text field and stop at the second period?

2

Hi Chris,

You can use Split() with a period as delimiter:
image

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

image
image754×433 24.6 KB

Regards,
Piet

3

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