How do I Split a Field?

Splitting the data in a field or column into multiple columns can be done in a lot of ways in OPAL. Parsing commands like parse_csv or parse_json are best when there is a standard format specification to follow, such as CSV. If the data in the column is an unformatted string, commands like split, or substring can be an effective choice. If all else fails, the extract_regex verb is a powerful tool to pull data from a column.