Sub GetAllWildcardMatches($source As String, $wildcard As String) As String


Searches $source for all occurrences of $wildcard. $wildcard is a wildcard expression that consists of a start text, an asterisk, and an end text with the following syntax:


StartText*EndText


GetAllWildcardMatches is case-insensitive. Each match is listed on a new line, separated by a carriage return/line feed. If $wildcard is not found, GetAllWildcardMatches returns an empty string.


Parameters


  • $source ... String expression in which the search is performed.
  • $wildcard ... Wildcard expression to search for (StartText*EndText).


Example:

Dim $s, $s2

$s = "a number or a text or a date"
$s2 = GetAllWildcardMatches($s, "or*t") 'returns two lines in $s2 = "or a t"#13#10"or a dat"


The extracted lines can be sorted with the function SortStringLines.