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.
Solved! Go to Solution.
Actually, this solution by @CarlosFigueira gave me a great idea, and is working now.
Actually, this solution by @CarlosFigueira gave me a great idea, and is working now.
User | Count |
---|---|
258 | |
108 | |
93 | |
57 | |
41 |