@Sarah_Dunn welcome to the KNIME forum. Here is another approach
kn_forum_46078_import_text_and_split_column.knwf (47.0 KB)