I have to trim this data :[{"lat":"44.88383725", "lon":"-93.28145902"}] and have values in two separate columns.I used Parse and multifield formula too but no use.Could you help me with suitable Reg exp or any other way to get only values.
Thank you
Solved! Go to Solution.
Use the RegEx tool. Set the Output Method to Parse.
(\d+\.\d+).*?([-]*\d+\.\d+)
That should do the trick.
Cheers,
Mark
Thanks a lot.It really did the trick.I take a bow.