Converting legacy data type

I just found that a few properties in our lexicon are denoted as strings instead of numbers. When looking back, I realized we were logging this data with a “$” in front of the float value. We would like to be able to do numerical comparisons and calculations with this data, and while it is easy to fix the incoming values, I could not think of a good method to remove the $ from the legacy data. I was considering making a lookup table converting strings with a $ to the same number (without a $), but it seemed tedious and would require me creating an entirely new property instead of updating the currently used one. Does anyone have any advise? Thank you in advance.

0 replies

Be the first to reply!