split多个空格视为一个,如何在多个空格上执行拆分？

I have a Windows Forms application. I am importing CSV files (from a website questionnaire) into a DataGridView.

I then need to populate the different columns in the DataGridView with the relevant information. A few people have filled in the Questionnaire incorrectly and I need to split the answers into the correct columns. I will give you an example -

Some people have filled 2 different e-mail addresses into the same answer. They are separated with a space, an equals sign and another space. One e-mail needs to go into one column and the other e-mail into another column.

How could I split these up? I know that a 'normal' split will deal with one 'space' and a character but I'm not sure how I need to split a character (equals sign) that has a space both before and after it.

Could someone give me a few ideas?

I appreciate the help.

解决方案'three emails in one field

Dim test As String = "foo@bar.com = bar@foo.com   foobar@foobar.com"

Dim s() As String

s = test.Split(New Char() {" "c, "="c}, StringSplitOptions.RemoveEmptyEntries)