Search and replace function together in Power Query

[spycein]

Hello Everyone,
i am looking for custom function which would check If contains "Dr" or "Cr" and replace the same will nothing and also multiplies with 1 if the word is "Dr" and multiplies with -1 if the word is "Cr".
For example, following is the sample table:

268740.00 Cr

1652420.00 Cr

22228.00 Dr

I am looking for result as follows:​

-268740​

-1652420​

22228​

Hope i explained my query properly. Thank is advance.
Best Regards,

 

[Alex Blakenburg]

Are you specifically trying to do it using M Code ?
This is simple to do using the interface.
eg
Transform > Replace Values
" Cr" with "-" without the quotes
" Dr" with "" without the quotes
Change the datatype to a numeric data type.

You could also use Split and then a conditional column to multiply by 1 or -1