Cleaning up amounts expressed with abbreviations

Question

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?

binu_acs · Answer

@NMorgan Another method

Convert_200423.yxmd

ShankerV · Answer

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

ShankerV · Answer

Hi @NMorgan

One way of doing this.

Many thanks

Shanker V