in reply to Tricky Problem

What happens if you have:

100-250,MA,150
75-300,MA,350

As others have commented, we have no idea what the logic behind your parsing is, so it's difficult to suggest anything. Although Cnn seems to have tried.