SQL REST API - Need to return part of a text field

[byoungman (Bill Youngman)]

I'm on ES 6.4 and am trying to write a sql query using the SQL REST API and one of the requirements is that I display a time which is part of a text field. So far I'm not able to find anything like SUBSTRING & PATINDEX equivalent that I can use so how could I go about doing this?

Example:

65.7

I need to be able to pull out the value (65.7) and return it in my query so that I can build a report off of it.

TIA,
Bill Youngman

[nik9000 (Nik Everett)]

Substring is showing up in 6.5. Until then I think you are stuck doing it on the client side if possible.