VBScrip Regular Expressions

[alexkeel79]

I am new to VBScript Regular expressions and I am trying to parse a string which includes the lastname, firstname of a user. I tried "LASTNAME\, [A-Z]" and "[A-Z], \FIRSTNAME" but the problem I ran into is that with the last name pattern unless the full last name is used as the search string there is no match. Is there any character such as '*' in SQL that I can use to say there may or many not be another character(s) before the '\'? THanks.

 

[tsuji]

You have to rephrase the question and the description of the data structure. No crystal ball here.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/vsproPattern.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886