>Chief Probation Officer >>I need to return
>CPO >>
*--------------------------------------------------------------------------- function yyy1() local RegExp, Match RegExp = CreateObject('VBScript.RegExp') RegExp.Global = TRUE RegExp.IgnoreCase = FALSE *RegExp.Pattern = '[^\s]+\s*' *RegExp.Pattern = '\w+\s*' RegExp.Pattern = '\w+[^\w]*' select d_name, ; padr(yyy2(RegExp, d_name), 16) as initials ; from Dossier endfunc *--------------------------------------------------------------------------- function yyy2(RegExp, s) local Match, Out Out = '' Match = RegExp.Execute(s) for i = 0 to Match.Count - 1 Out = Out + left(Match.Item[i].Value,1) endfor return Out endfunc *---------------------------------------------------------------------------