I have a field {INMAST_VIEW.Map_Coordinates} that looks like this:
-96.123456/30.123456
I need to separate the lat from the long and put them in separate fields on the report.
I have used
Right ({INMAST_VIEW.Map_Coordinates},9 ) and
Left ({INMAST_VIEW.Map_Coordinates},10 )

but end up with a few fields that display the below
-96.1234/ or /30.12345

How can I make sure that everything to the right of the "/" is put in the long field regardless of the length, and everything to the left of the "/" is put in the Lat?

THIS IS AWESOME! Thank you so much for your help! I had Tried Split first but didn't get the [1] or [2] part at the end right. It works like a champ now!

-Cory