Parse the first word out of a string

[wonka1234]

Hi,

I am having trouble parsing the first word out a string.

Ie 

Qualified - All fields - 11012021 - 11302021.zip

WPS Report (page 3) 11012021 - 11302021.zip

to become

Qualified

WPS

[Felipe_Ribeir0]

Hi @wonka1234 

You can use the formula getword([Field1], 0) to get the first word

[Emmanuel_G]

Hi @wonka1234 

Find in attachement another way to do that using regex expression.

[Felipe_Ribeir0]

Hi @wonka1234 

It worked?