Replace/Convert Values in columns

[Ali123]

I have values in my column like : $2B ,$22M, $15B and some are 'unknown'.
How we can convert these values into digits .

for example $2m --> 2000000.

@amitchandak

@moizsherwani 
@MFelix 

regards

[tamerj1 · Accepted solution]

Hi @Ali123 
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcC

Salary New = 
VAR Salary = Salaries[Salary]
VAR Length = LEN ( Salary )
VAR Number = MID ( Salary, 2, Length - 2 )
RETURN
    SWITCH ( 
        TRUE ( ),
        CONTAINSSTRING ( Salary, "M" ), 1000000 * Number,
        CONTAINSSTRING ( Salary, "B" ), 1000000000 * Number
    )

[tamerj1]

Hi @Ali123 
Would you please provide some sample data?

[Ali123]

Name	Salary
Abubakar	$22M
Akbar	$1B
Asgar	Unknown
Arif	$2M