in reply to How to Split on specific occurrence of a comma
Your data model is broke.
Very next sentence:"Unfortunately, I can't change the way the data is provided.". How does your response address either this issue or the question asked?