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

Elastic Stack Elasticsearch
1

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

2

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

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.