RegexpFindOnUrl

=RegexpFindOnUrl(string url; string regexp;
int group; [string xmlHttpSettings]) : array

Purpose

Fetches the url and returns the (array) result from regexp expression.

Similar to XPathOnUrl, RegexpFindOnUrl returns an array if there are several matches on the requested page.

You can control the HTTP request (such as header and form variables) using the xmlHttpSettings (Optional). See HttpSettings.

This function is cached.

Example

=RegexpFindOnUrl("http://google.com","<title>([^>]*)</title>",1)  
=> "Google"

See

Guides

• Working with arrays in Excel
• An SEO’s Guide to RegEx

Related Functions

• GetTextOnUrl
• CsQueryOnUrl
• XPathOnUrl
• RegexpFindOnUrl