I got Dups....

hi2019

Hi,

I am trying to only show the roman numeral only but now its showing both 4 IV at the end of Pay Name- I think I have to correct this formula or add another formula to remove this -please help

elseif Contains([Pay name], " 2" ) THEN [Pay name]
+ 'II'

elseif Contains([Pay name], " 3" ) THEN [Pay name]
+ 'III'
elseif Contains([Pay name], " 4" ) THEN[Pay name] + 'IV' ELSE [Pay name]

is this part of a larger formula - am sure it is from this part though

thanks!!!!!

Reporting

Accepted answers

All comments

Qiu

@hi2019
Can you give some input and desired output?
I can not quite get your question, sorry.

flying008

Hi, @hi2019

Try this formula:

Left([Pay Name], Length([Pay Name]) -1) + Switch(Right([Pay Name], 1), Right([Pay Name], 1), '1', 'I' , '2', 'II', '3', 'II', '3', 'III', '4', 'IV', '5', 'V', '6', 'VI', '7', 'VII', '8', 'VIII', '9', 'IX')

hi2019

It didnt work but it could be because of how I explained

how can I trim it only for those roman numerals to show only

Carlithian

It sounds like you are wanting to swap the arabic number with the roman numeral

E.g

Litten 4 would become Litten IV

I would recommend using a find replace and a text input

Numeral Repacement.png

hi2019

I am not too famaliar with this tool

apathetichell

There is a weekly challenge on this. Look at the solutions for the weekly challenge. https://community.alteryx.com/t5/Weekly-Challenges/Challenge-183-Roman-Numeral-Math/td-p/470370

hi2019

whoa - I think I am more confused lol

I just thought I could do a formula or replace?

apathetichell

oh! My bad - I thought they were more complicated. Your problem with your original is that you have the if statement to add the simple numeral. - but you never replace the original number. so intead of:

elseif Contains([Pay name], " 2" ) THEN [Pay name]
+ 'II'

elseif Contains([Pay name], " 3" ) THEN [Pay name]
+ 'III'
elseif Contains([Pay name], " 4" ) THEN[Pay name] + 'IV' ELSE [Pay name]

try

elseif Contains([Pay name], " 2" ) THEN replace([Pay name],'2','II')

elseif Contains([Pay name], " 3" ) THEN replace([Pay name],'3','III')
elseif Contains([Pay name], " 4" ) THEN replace([Pay name],'4', 'IV') ELSE [Pay name]

BUT if you start getting into complicated roman numerals - go into the weekly challenge for a solution.

hi2019

ok let me try --- also if i am looking for 2, 02 I can just add,

, "02") to add after the 2 in the above? etc for 3, 4, etc

apathetichell

Yup. you could also swap the replace for regex_replace - swap the replace term to '0*2' - which means any number of 0's (including 0)

OTrieger

@hi2019 I'm really confused from your post. You are asking for help, the guys here asking that you will share some data from your end. Even a snippet of the data that you are trying to transform, so any of the solutions that the guys were giving you are like walking in a dark ally where you cannot see anything. If you want to get help help us to understand what you are facing and what you would like to achieve.

OTrieger

You are right!

He is asking a question that not telling anything.

hi2019

its so odd

it grabs and does it for half of them but I cannot see why its not grabbing the other ones ! I dont see different spaces in them?

Also, for the way to grab any amount of 0 inbetween - do I put that in both sectiobs of where the 2 is?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335