REGEX, Trim everything after the first punctuation

Question

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

binu_acs · Answer

@wonka1234 One way of doing this

Regex_1028.yxmd

DataNath · Answer

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

Parse up to punctuation.yxmd

gautiergodard · Answer

hey @wonka1234

Here is also a non-regex way to do it

parse.yxmd