Cleaning up amounts expressed with abbreviations

[NMorgan]

Hello, I'm an Alteryx beginner and I'm looking for some help in cleaning up some sample data which has amounts expressed with abbreviations such as K for Thousands and M for Millions.

As an example I have data that looks as per below:

$102.5M

$32M

$220K

$2M

I'd like this to show as a plain number so the first would be 102,500,000 etc. How do I go about doing this in Alteryx?

[ShankerV]

Hi @NMorgan 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @NMorgan 

Step 1: 

Step 2: 

([0-9.]+)(\u)

Step 3:

IF [RegExOut2]="M"
THEN [RegExOut1]*1000000
ELSE [RegExOut1]*1000
ENDIF

Many thanks

Shanker V

[binuacs]

@NMorgan Another method