CSV_PARSE

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

Syntax 

CSV_PARSE(text)

Examples 

Example 1

Input

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

Formula

CSV_PARSE(my_action.message)

Output

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