title: Regular expression for splitting a comma with the string
body: <p>I had to split string data based on Comma.</p>
  
  <p>This is the excel data:-
  <a href="https://i.stack.imgur.com/akNpy.png" rel="nofollow noreferrer">Please find the excel data</a></p>
  
  <p>string strCurrentLine="\"Himalayan Salt Body Scrub with Lychee Essential Oil from Majestic Pure, All Natural Scrub to Exfoliate &amp; Moisturize Skin, 12 oz\",SKU_27,\"Tombow Dual Brush Pen Art Markers, Portrait, 6-Pack\",SKU_27,My Shopify Store 1,Valid,NonInventory".</p>
  
  <p>Regex CSVParser = new Regex(",(?=(?:[^\"]<em>\"[^\"]</em>\")<em>(?![^\"]</em>\"))");
    string[] lstColumnValues = CSVParser.Split(strCurrentLine);</p>
  
  <p><a href="https://i.stack.imgur.com/Z5R1Y.png" rel="nofollow noreferrer">I have attached the image.The problem is I used the Regex to split the string with comma but i need the ouptut just like SKU_27 because string[0] and string<a href="https://i.stack.imgur.com/Z5R1Y.png" rel="nofollow noreferrer">2</a> contains the forward and backward slash</a>.I need the output string<a href="https://i.stack.imgur.com/akNpy.png" rel="nofollow noreferrer">1</a> and remove the forward and backward slash.</p>