Update column based on pattern

[ppr (Peter Preuss)]

Have a check if Group names will help for the implementation (Kindly note the Case insensitive option was used)

Grouped regex

@Poul_Riis it is recommended to use the format button </> from the editor when sharing code snippets. Maybe you are looking for the following: retrieve the information on which group name matched. Variables: [grafik] Flow: [grafik] we init a Regex with the pattern and run the regex: myRegex = new Regex(strPattern) myMatches = myRegex.Matches(strText) Then we do loop the matches and check for all non-empty group members the group name: arrMatchedGroups = (From t In m.Groups.Cast(Of …

And based on this building block we do have variant options for the implementation e.g. handling multiple additional groups.

For updating the column value we would recommend to start within a for each row