Problem in splitting values

According to Expresso[^], this regex will give what you want:

((?>"[^"]+")|[^;]+)

It will split

France;Japan;Russia;China;"India;New-Delhi";"NewZeland;Wellington";England

into

France
Japan
Russia
China
"India;New-Delhi"
"NewZeland;Wellington"
England

Then you can use .Trim('"') on the individual results to remove any quotes there:

string csvline ="France;Japan;Russia;China;\"India;New-Delhi\";\"NewZeland;Wellington\";England";
string pattern = "((?>\"(?:[^\"]+)\")|[^;]+)";
Regex rgx = new Regex(pattern);
var matches = rgx.Matches(csvline);
/// remove the quotes and get the words in order.
string[] words = matches.Cast<Match>().Select(m => m.Groups[1].Value.Trim('"')).ToArray();

Solution 1: Never use as separator a char that appear in data.
I guess you see why it is a problem.
If you can change your csv file, use a separator that is unused in that data at csv generation.

Solution 2: it gets pretty complicated.

string csvline ="France;Japan;Russia;China;""India;New-Delhi"";""NewZeland;Wellington"";England";
/// replace all ';' with ','
csvline= csvline.Replace(";", ",");
/// search all quoted substring with a , inside and replace it with ;
string pattern = "(""[^""]+),([^""]+"")";
Regex rgx = new Regex(pattern);
Match m = rgx.Match(csvline);
while (m.Success)
{
    csvline= rgx.Replace(csvline, "$1;$2");
    m = rgx.Match(csvline);
}
/// remove the quotes
csvline= csvline.Replace("""", "");
/// split at ,
string[] words = csvline.Split(",");

To see what a regex is doing https://www.debuggex.com/[^]
I eventualy found a tester that generate C# code https://www.myregextester.com/index.php[^]

Try this

string test = "France;Japan;Russia;China;\"India;New-Delhi\";\"NewZeland;Wellington\";England";
List<string> Jointarray=new List<string>();
foreach (Match match in Regex.Matches(test, "\"[^\"]*\""))
{
     Jointarray.Add(match.ToString());
     test = test.Replace(match.ToString(), "");
}
Jointarray.AddRange(test.Split(';').ToList().Where(x => !string.IsNullOrEmpty(x))); 

Now, Jointarray is what you are looking for.

Regards,

First, I'd suggest looking at csv parsers (just swap the comma for the semi-colon). Dealing with strings inside csv strings is a problem that has been looked into in detail under the guise of CSV Parsing:

this one looks good and lists the Quote character as something it deals with:
A Fast CSV Reader[^]
This would be my first choice

Another option might be to use Regular Expressions focusing on look-ahead and look-behind groups. This can be a little overwhelming if you have not used it before.

My final suggestion would be to Split my the Quote character first, then split by the semi-colon.

A word of warning: Some of the options will not work if there is a chance of having a malformed string (i.e. un-paired quote chars):

var strings = mystring.Split('"');
List<string> result;


//Always expect ;" or ";
if(strings.Length>1){
  //The first might be the Quoted string, so this needs work
  if(strings[0][strings[0].Length-1]!=';'
    Throw new Exception("You get the idea");

  result.AddRange(strings[0].Split(';');
  
  
  for(int x = 1; x < strings.Length - 2; x++){
    //Check the first and last char.  Must both be ";" or neither.

      result.AddRange(strings[x].Split(';');
  }

  //Finally test the last sting

  result.AddRange(strings[last].Split(';');
}

return result.ToArray();

Hope that helps ^_^
Andy

try this solution

string value ="France;Japan;Russia;China;\"India;New-Delhi\";\"NewZeland;Wellington\";England'";
          string ReplaceDoubleQuote = value.Replace("\"", " ");
          string[] words = ReplaceDoubleQuote.Split(';');