This image shows the Split Column dialog open to change the CHANNEL_ID column into two parts, separating the ID dash portion for the CHANNEL_ID, and placing the numberical portion in a column called CHANNEL_NUMBER.