Convert Text to Collection

[emfuentes27]

I have a SharePoint text field that stores a string that looks like this:

Filing: 1/11, Map File Name: 12345, Crops: A, B, C, D; Filing: 2/11, Map File Name: 54321, Crops: E, F, G, H; Filing: 3/11, Map File Name: 56789, Crops: I, J, K, L;

I need to convert this to a collection, so it can be used to provide data to a DataTable. So far I've been able to split it using the ";" as the separator:

ClearCollect(cropsFromField, Split(theCrops.Text, ";"));

And I get something like this:

The issue now is that I don't know how split into Filing, Map File Name, and Crops (uses commas). I would need to look like this:

Any suggestion? I'm guessing I need to do a further splitting, but having the Crops separated by commas also is making it more difficult. Thanks in advance.

[emfuentes27 · Accepted solution]

Actually, this solution by @CarlosFigueira gave me a great idea, and is working now.