Convert string CCY Amount (in millions) to number

Question

Hi,

How do i convert a string of CNY Amount (in millions) to number?

eg. CNY 200M -> 200000000 (can ignore the ccy)

Raj · Answer

You can use find and replace tool

to replace "M" with "000000" or use formula tool to achieve this.

Qiu · Answer

@Sohdaw 
This weekly challenge should help.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-235-Spell-It-Out-For-Me-Part-2/td-p/640995