Hi All,
Would anyone know how to extract from a VBA string variable, from between the FIRST comma+space and the FIRST closed parenthesis below?
originalString="IQR (Sec 2.2, Table, Row 2, Col 2) Need to delete 2nd space between 'be' and 'provided' (Sev 4, Pri 4)"
so that the result would be...
result="Table, Row 2, Col 2"
PS: After the 1st comma, there can be from 0 to unlimited amount of commas.
I thought this would be a simple one to figure out or find in the forums, but I've had a hard time getting the above result...
Thanks so much,
JMC
Bookmarks