| Excerpt |
|---|
This example shows how you can split data from a single column into multiple columns using |
...
delimiters |
...
. |
- single-pattern delimiter: One pattern is applied one or more times to the source column to define the delimiters for the output columns
- multi-pattern delimiter: Multiple patterns, in the form of explicit strings, character index positions, or fixed-width fields, are used to split the column.
...
- .
Source:
In this example, your CSV dataset contains status messages from a set of servers. In this case, the data about the server and the timestamp is contained in a single value within the CSV.
...
| server | year | month | day | time | Status |
|---|---|---|---|---|---|
| admin.example.com | 2016 | 03 | 05 | 07:04:00 | down |
| webapp.example.com | 2016 | 03 | 05 | 07:04:00 | ok |
| admin.example.com | 2016 | 03 | 05 | 07:04:30 | rebooting |
| webapp.example.com | 2016 | 03 | 05 | 07:04:30 | ok |
| admin.example.com | 2016 | 03 | 05 | 07:05:00 | ok |
| webapp.example.com | 2016 | 03 | 05 | 07:05:00 | ok |
| D s also | ||
|---|---|---|
|
