Given this string:
SET @text = "<a href=""https://salesforce.stackexchange.com""target=""_blank"">Salesforce</a>
<a href=""https://stackoverflow.com"" target=""_blank"">Everything else</a>"
And this function:
SET @matching = '\s+(?:[^>]*?\s+)?href="([^"]*)"'
SET @output = RegExMatch(@text, @matching, 1)
How can I manage to find and print an arbitrary number of matches in my string? E.g. in above example, I would like to present e.g. a rowset with each URL in each row.
Not a pretty solution, but here's what I use:
%%[
SET @text = "<a href=""https://salesforce.stackexchange.com""target=""_blank"">Salesforce</a><a href=""https://stackoverflow.com"" target=""_blank"">Everything else</a><a href=""https://google.com"" target=""_blank"">Search</a>"
SET @href = BuildRowsetFromString(@text, 'href="')
for @i = 1 to Rowcount(@href) do
SET @endhref = BuildRowsetFromString(Field(Row(@href, @i),1), '"')
OutputLine(Concat(Field(Row(@endhref, 1),1),"<br>"))
next @i
]%%
Output:
https://salesforce.stackexchange.com
https://stackoverflow.com
https://google.com
</a>s and iterate through the number of with multiple regexmatches with looping (variable i). RegExMatch(@text, @matching, @i) – Johannes Schapdick Oct 10 at 8:36Set @text = '<a href="https://salesforce.stackexchange.com" target="_blank"> ... 'i would nearly think that your code is wrong ;) – Johannes Schapdick Oct 10 at 9:20