CSV_PARSE_TO_OBJECTS

Parses CSV-formatted text with auto-detection of the delimiter character and parses output into an array of objects.

Syntax 

CSV_PARSE_TO_OBJECTS(text)

Examples 

Example 1

Input

{
  "my_action": {
    "message": "first, second, third\n1, 2, 3"
  }
}

Formula

CSV_PARSE_TO_OBJECTS(my_action.message)

Output

[
  {
    "first": "1",
    "second": "2",
    "third": "3"
  }
]
Was this helpful?