Remove space before .doc/.docx if it exists

[wonka1234]

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

[binuacs]

@wonka1234 

[wonka1234]

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

[binuacs]

@wonka1234 

[Raj]

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

[flying008]

Hi, @wonka1234 

FYI.

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