Trim the Field

[JC_dup_130]

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

[MarqueeCrew · Accepted solution]

@JC_dup_130,

Use the RegEx tool.  Set the Output Method to Parse.

(\d+\.\d+).*?([-]*\d+\.\d+)

That should do the trick.

• Output 1:
  • 1 or more digits
    • followed by
  • A decimal place
    • followed by
  • 1 or more digits
• Junk
  • Anything
• Output 2:
  • 0 or more negative signs
    • followed by
  • 1 or more digits
    • followed by
  • A decimal place
    • followed by
  • 1 or more digits

Cheers,

Mark

[JC_dup_130]

Thanks a lot.It really did the trick.I take a bow.

[MarqueeCrew]

You can adjust the data types.

Bowing 🙇 back.