Regular Expressions 1

[Swi]

Could someone elaborate as to why the following code does not work? It is not flagged names that are last name, first name. Thank you.

    '-- pick apart name by removing prefix,
    '     suffix, and title
    strName = Trim(fncExtractSuffix(strName))
    strName = Trim(fncExtractPrefix(strName))
    strName = Trim(fncExtractTitle(strName))
    mobjRegExp.Global = True
    '-- check for last, first combo (Doe, Jo
    '     hn) ----
    mobjRegExp.Pattern = "[^ \f\n\r\t\v\,]+\,\s+\S+ "

    If mobjRegExp.Test(strName) = True Then
        Call subParseLastFirst(strName)

Swi

 

[tsuji]

[1] There is a spurious space at the end of the pattern which should not be intended, a typo?
[tt] mobjRegExp.Pattern = "[^ \f\n\r\t\v\,]+\,\s+\S[highlight]+"[/highlight][/tt]

[2] And then, it matches "Doe, Jo\r\nhn" with a line feed after Jo which shouldn't be intended. It succeeds because the it is not instructed to match the whole _trimmed_ string. It should really better be this, I guess-and then the global property is irrelevant.
[tt] mobjRegExp.Pattern = "[red]^[/red][^ \f\n\r\t\v\,]+\,\s+\S+[red]$[/red]"[/tt]

[3] comma can be put literally without escaping. You can sure "escape" it too.

[4] And then exotic case, such as "Doe, J,oh9n" would still be matched. Area for tightening...

 

[Swi]

Thank you for the response and explantion. It works great. Thank you again.

Swi