Remove space before .doc/.docx if it exists

Hi,

I have a bunch of documents read into alteryx by directory tool.

Some have a space before .doc/.docx.

How can I remove that?

Ie: cool_document .doc

should be cool_document

thanks

Custom Tools

Accepted answers

@binu_acs sorry the output should be cool_document.doc or .docx. Not removing the docs

You could have tried data cleansing tool as well where you can select remove all spaces.
this would have provided same output.

FYI.

REGEX_Replace([Email], '(\s+)(?=.doc|.docx)', '')

录制_2023_12_20_14_30_32_725.gif