Retreive first word in text field

[DustinCoke04578]

Hi, is there a simple text equation that can be used to get the first word of a string of text?

[KnackPros]

You can use the function extractRegex, then pass it a regular expression.

For example, given the fields My Field and Text Formula:

Here’s how you would extract the first word of My Field:

extractRegex({My Field}, ^([\w\-]+))

Does that work for you?

Ian
Knack Pros

[DustinCoke04578]

Thank you! Resolved!