Regular Expression for Inconsistent Multiple Spaces

[Yoichi]

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,