Regular Expression (VB.NET)

Question

How I can convert this:

, ...Name: John, LastName: Smith, Gender: Male, ...

into

, ...Name: John, Gender: Male, ...

Notice I replace " LastName: XXXXX," by "" (empty chain)

I've tried with

'Remove LastName...
pattern = " LastName.*,"
replacement = ","
msAccessQuery = Regex.Replace(string, pattern, replacement)

Thanks in advance.

Answer 1

pattern will be:

 \s*LastName:[^,]*,