this code produces expected result:
s.Trim('\'')
.Split(new[]{"','"}, StringSplitOptions.RemoveEmptyEntries)
it removes 1st and last '
symbols and splits by ','
output
Malaysia Index
Mc'DONALDS CORPORATION
McDonalds
Me,dia
2
solved How split string in c#? (no, not string.split() 🙂 [closed]