Splitting a String with a Delimiter That is Present in the String Itself

[ashwin.ashok ((TheCodingTheory))]

I’m sorry for the confusing title, but the issue I am facing will become evident as yo read on.

I have a block of string in the form of “Option1, Option2, Option3…”
Splitting this is easy, with StrVariable.Split(","c)

But some of the options may contain the delimiter itself:
“Option1, Option2, Option3…Optio,n10, Op,tion11”

Help would be most appreciated.
Thanks in Advance!

Kind Regards,
Ashwin A.K

[ppr (Peter Preuss)]

the sample values are very general and maybe the approach needs to be shifted more on the details. Maybe the comma can be detected and removed with the help of regex.

here the comma is identified if it stands between 2 small case letters

[ashwin.ashok ((TheCodingTheory))]

Hi @ppr,

Thank you for your response, I will add more details to my query.

I wish to separate the values as they are, i.e., when I split them into an array, the items should be {“Option1”, “Option2”, “Option3”…“Optio,n10”, “Op,tion11”}.

Here are is an example of the actual string(just a portion of it that contains two items)
“All Indirect.Employee Bonuses, Awards and Incentives,
OPS Catalog Only.Employee Bonuses, Awards and Incentives”

Writing it down once more, highlighting the commas present inside of the items themselves:
“All Indirect.Employee Bonuses, Awards and Incentives, OPS Catalog Only.Employee Bonuses, Awards and Incentives”

As you can see, I won’t be able to split them into two items, it will come back as four items.

I only wish to retain those commas that come before “All Indirect.” and “OPS Catalog”
From your description above, this is the expression I came up with, but I’ve screwed up somewhere.

,(?=[(All Indirect.)|(OPS Catalog)])

Kind Regards
Ashwin A.K

[ppr (Peter Preuss)]

in that case you are close bound to the values, maybe this would work:

[ashwin.ashok ((TheCodingTheory))]

It helped @ppr,
Thank you so much!