Hi guys, 

Hope you might be able to help. I have a column that contains financial values, however littered with various text such as currency codes and other values (no consistent patterns). I need to be able to extract any numbers from this column. In excel I would use something like this Excel: Extract number from text string  . 

However, haven't had much luck with that in Apptio so far. I was doing some searching and saw regex replace which I thought may help, but not well acquainted with that. 

Has anyone here managed to achieve this without too much effort? Thanks, Kev 

Hello Kevin - I have asked around I have heard back with the same answer you have looked at, RegEx. I have a link for you that is specific to Apptio the article also has an external link for information. https://tbmcouncil.jiveon.com/docs/DOC-4927?commentID=27114#comment-27114 

I hope this helps!

Hi Renee, very kind of you to take a look! 

What I did in the end as a placeholder was a straight forward \D in regex, and then another formula to remove the last two digits (cents/pence) as I couldn't find a way to take into account the period. That got 99% of the cost in  

I'll spend some time soon looking at a way to fix it precisely, but on the upside have upskilled in the regex department! Kev