extract text between brackets

  • 0
  • 2
  • Question
  • Updated 4 years ago
  • Answered
hi can someone let me know of the formula to enable me to extract text from between two brackets?

Example text held in text box (List box):

'Test (TE)'

I would want to return 'TE'.

I have tried 'Part([Event Type],2,"(")' but that would return 'TE)'.

Simple request I am sure but appreciate the help :)
Photo of stuaz

stuaz

  • 10 Points

Posted 6 years ago

  • 0
  • 2
Not tested, but try this

Left(Right([Event Type],"("),")")
Photo of stuaz

stuaz

  • 10 Points
Perfect thank you.
Photo of Leon

Leon

  • 0 Points
Thanks very much.

I had a slightly different (and simpler) need: I used this to extract latitude and longitude from a field that was in the form (lat, long):
Lat: Left([lat_long_field],",")
Long: Right([lat_long_field],", ")