Separate content

This command is useful if you want to split a column into several columns. For this action you need to know how many columns will be created and you need to specify their names.

case separate column 'longtext' into 'foo', 'bar', 'remaining' with value '-';

If the original value contains more tokens than new columns defined the remaining tokens will be concatenated in the last column. If the original value has less tokens than columns specified, remaining columns will be credited of a value (none)