Roman to Integer conversion

This is a weird question but i've faced today with one of my data sheet.

I got data with roman numbers into it like I,II,III,IV,V etc till X(10). Though i've converted these numbers to integer using formula tool like if 'I' then 1 else 2 and so on. But i've to write it 10times for each number.

Is there a way to convert Roman numbers to Integer value?

Workflow

Accepted answers

LordNeilLord

Hey @AnandKumar1

Here's my go at it

romannumerals.yxmd

All comments

Thableaus

Hi @AnandKumar1

There's an add in created by @jdunkerley79 that contains a function with this ability to convert Roman values to integers.

You can check out in his blog:

https://jdunkerley.co.uk/2019/04/09/an-overview-of-the-alteryx-abacus-add-in/

Cheers,

Thableaus

You may also check it here:

https://community.alteryx.com/t5/Engine-Works-Blog/An-Overview-of-the-Alteryx-Abacus-Add-In/ba-p/398982

LordNeilLord

Hey @AnandKumar1

Here's my go at it

romannumerals.yxmd

AnandKumar1

@LordNeilLord That was awesome

@Thableaus Thanks for sharing that link. Will try to use that too.

JReid

Just saying, this question would make an awesome weekly challenge

AYXAcademy

We think so, too @JReid ! Thanks @LordNeilLord for sending this to our Weekly Challenge queue...can't wait to work it into the mix!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703