Separate
Last updated
Was this helpful?
Last updated
Was this helpful?
Separates a column with delimited values into multiple columns or rows.
Click "+" button and select "Separate".
You can also select "Separate" from the column menu of the column to separate.
Select column to separate from "Column to Separate" dropdown.
Specify separating text by selecting one from "Separate by" dropdown.
Specify names of resulting new columns, separated by comma, in "New Column Names" text field.
Specify parameters in the "Parameters" section.
Remove original column - The default is TRUE. Set FALSE to drop the original columns.
Guess column data type - The default is FALSE. Set TRUE to automatically guess the most possible data type for the columns in the result.
Drop or merge extra values - The default is "warn". Set "drop" to drop any text beyond the number of the new columns, "merge" to merge the text with the value in the last column.
NA goes to - You can control what happens when there are not enough pieces. Leaving it "Choose..." fills from the right. "Right" fills with missing values on the right. "Left" fills with missing values on the left.
Click "Run".
You can select "Separate" from the column menu of the column to separate, then select "Separate to Rows by ..." submenu, and select the separator.
Select column to separate from "Column to Separate" dropdown.
Specify separating text by selecting one from "Separate by" dropdown.
Specify parameters in the "Parameters" section.
Guess column data type - The default is FALSE. Set TRUE to automatically guess the most possible data type for the columns in the result.
Click "Run".
