Exploring ArangoDB AQL: Extracting Text using Regular Expressions

 In ArangoDB AQL, you can use the REGEX_SPLIT function to extract parts of a text based on a delimiter using a regular expression. Here's an example of how you can use it:

LET text = "Hello|World|How|Are|You"
LET parts = (
  FOR part IN REGEX_SPLIT(text, "\\|")
  RETURN part
)
RETURN parts

In this example, we have a text string "Hello|World|How|Are|You" where each part is separated by a pipe character (|). We use the REGEX_SPLIT function to split the text into an array of parts based on the delimiter regex pattern "\|".

The result will be an array parts containing the individual parts extracted from the text:

[
  "Hello",
  "World",
  "How",
  "Are",
  "You"
]

You can modify the regex pattern in the REGEX_SPLIT function to match your specific delimiter or pattern as needed.