Skip to main content

Extracting Matching Text in Strings

AMPS includes a function, REGEXP_MATCH, that returns the first match of text within a string.

REGEXP_MATCH​

REGEXP_MATCH​

REGEXP_MATCH(string_to_transform, pattern_or_text_to_match)

Returns the first occurrence of the pattern_or_text_to_match. This can be either a literal match or PCRE pattern.

Parameters

  • string_to_transform: The string to search within.
  • pattern_or_text_to_match: The literal text or PCRE pattern to match.

Returns

The first matching text, or NULL if there is no match.

Example

The following expressions all evaluate as true:

REGEXP_MATCH('sheepdog', 'dog') > 0

REGEXP_MATCH("30dogs", "^[0-9]*") == "30"

The following snippet shows REGEXP_MATCH constructed as a field:

<Field>COALESCE(REGEXP_MATCH(/petDescription, "cat|dog|bear"), "back away slowly, I don't know what that is") as /animal_type</Field>

With the following data:

{"petDescription": "tabby cat"}
{"petDescription": "havanese dog"}
{"petDescription": "grizzly bear"}
{"petDescription": "blue gerbil"}

Would result in:

{"petDescription":"tabby cat","animal_type":"cat"}
{"petDescription":"havanese dog","animal_type":"dog"}
{"petDescription":"grizzly bear","animal_type":"bear"}
{"petDescription":"blue gerbil","animal_type":"back away slowly, I don't know what that is"}