REGEX, Trim everything after the first punctuation

[wonka1234]

Hi,

sample string:  This string could also contain _ , . , - . I want to trim everything after the punctuation.

ACF2.SRP.XML

What im getting:

ACF2SRPXML

my formula:

Trim(REGEX_Replace([FileName], "\W", ""))

What im expecting

ACF2

[Matthew]

this should work:

REGEX_Replace([Field1], '([\w_]*)|.*', '$1')

[gautiergodard]

hey @wonka1234 

Here is also a non-regex way to do it

[DataNath]

Could also use RegEx in parse mode with the following which will just take everything up to the first non-word (or underscore) character:

[binuacs]

@wonka1234 One way of doing this