Extract from dynamic expression

Need help Database
1

Hi there,

I want to add a dynamic text to my database and want to save a part of a text. Like if the text is “text.test.test2” I would like to only add “text” to the database.

Is there a dynamic expression for this?

2

Use regex or split by

3

Thanks. How should I exclude “.test.test2”?

4

As Jacob said, use the :split by operator, enter a period as the character to split by, and add the :first item operator to the end of the expression to get the first item in the split.

5

Thanks! Worked like a charm.

1 Like