Convert string to number with decimal

Hi there, can anyone help me mutate a string into a decimal-formatted number for geo-points?

For example, I have a CSV with fields containing: -115168598

....which needs to be: -115.168598

My first attempt just gave me -115:

ruby {code => "event.set('Ypos', event.get('Ypos')/1000000)"}

Thank you.

I have not tested it, but you could try

ruby {code => "event.set('Ypos', event.get('Ypos').to_f/1000000)"}

Thank you!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.