It reads every number and assigns it a value, 1 that are before V or X will be -1.
Operators are assigned a value 0. a running number column is created to group them, with an operator increasing the number by 1. The first number will have the group 0
sum the numbers up and concat their operators by their group numbers, join them together, have a running multirow formula to perform the operators accordingly
Had to get some inspiration from the solutions on how to manage the negative 1.
Nonetheless, got to the solution!
Created it to take on any form of roman numerals expressions, just need to modify number of columns in the regEx tool should the number of characters exceeds 1000.
My solution seems overly complicated.
On the bright side, I learned how to successfully use the R tool today.
I used R's eval function to evaluate the formula string.
I'm looking forward to seeing how this challenge SHOULD be done!
Here's my solution. The hardest part was evaluating the formula from the data.