Hi,
If your target string always starts with “MC” (and just after comma), the following expression will work.
System.Text.RegularExpressions.Regex.Matches(strData,"(?<=,)MC.*?(?=\s{2,})",System.Text.RegularExpressions.RegexOptions.Multiline)
Sample20220815-3v2.zip (3.2 KB)
Regards,