Splitting fields with Multiple Values
New to Knime how do i split down this information into different cells:
John & Sandra Doe
John and Sandra Doe
John Doe and Sandra Doe
John.Doe & Sandra Doe
John Sandra Doe
John Smith & Sandra Doe
John Smith & Sandra Jane
I need to be able to look at the cell and split it based on multiple characters like the &, the . the space and place them into separate cells
Then i want to combine the first names say John & Sandra and have a separate cell for Lastname. The name field can be random characters.
Any help much appreciated