| Page Item | Value |
| Title | VBScript Regular Expressions: Subexpression Substitutions |
| Description | An introductory guide to using regular expressions for string pattern matching in VBScript |
| Keywords | regexp, regular expression, regular expressions, visual basic, vb, vbscript, windows, asp |
| Robots Meta Tag | |
| Page Content | ASP Kitchen Search: Go Home | ASP Articles | ASP.NET Articles | Tools | Table Of Contents | What's New ASP Kitchen : Classic ASP Articles : VBScript Regular Expressions: Subexpression Substitutions VBScript Regular Expressions: Subexpression Substitutions Introduction Although there are a good range of text handling functions in VBScript, there are times when the required text replacement operation would be very tricky to carry out with a combination of calls to functions such as Replace , InStr and Left . In these cases, it is worth considering the use of VBScript's regular expressions, which are supported from VBScript version 5 upwards. An introduction to VBScript Regular Expressions is available. Complex Substitutions A typical use of regular expression substitutions is to process the BBCode tags into HTML. BBCode is a simplified version of HTML used by web-based applications such as the phpBB bulletin board. For example, if the user wishes to insert a hyperlink in their message then they can either use the BBCode: [url]http://www.aspalliance.com/[/url] .... which the bulletin board changes to: http://www.aspalliance.com/ . Alternatively, if anchor text is required then this BBCode is used: [url=http://www.aspalliance.com/]AspAlliance.Com[/url] .... which the bulletin board changes to: AspAlliance.Com . Changing [url]http://www.aspalliance.com/[/url] to a Hyperlink To change the first BBCode snippet to HTML, the following code can be used: % InitialString = [url]http://www.aspalliance.com[/url] Set RegularExpressionObject = New RegExp With RegularExpressionObject .Pattern = \[url\]([^\]]+)\[\/url\] .IgnoreCase = True .Global = True End With ReplacedString = RegularExpressionObject.Replace(InitialString, a href= $1 $1 /a ) Response.Write Replaced InitialString with: ReplacedString % The text replacement is achieved using the Replace method of a RegExp object. The method takes two arguments: The first argument is the string to be searched. The second argument is the replacement to be made. The regular expression specified by setting the Pattern property of the RegExp object is \[url\]([^\]]+)\[\/url\], which matches the following pattern: \[ = Matches an opening square bracket. url = Matches the text url . \] = Matches a closing square bracket. ([^\]]+) = Match one or more of any character except for the character enclosed in square brackets, which in this instance is a closing square bracket. This part of the pattern (which matches the URL between the BBCode [url] ... [/url] tags) is enclosed in parenthesis because it needs to be remembered for the substitution. \[\/url\] = Matches the closing BBCode url tag. Note that because square brackets ([ ]) and forward slashes (/) have special meanings in regular expressions, they have to be escaped by prefixing them with a backward slash (\). In this example, the URL specified between the BBCode [url] ... [/url] tags is remembered because it is within a set of parenthesis. As a result, it can be used in the replacement by using a dollar sign immediately followed by the number of the subpattern in the regular expression. There can be more than one set of parenthesis in a regular expression pattern. This makes it possible to reorder text in substitutions - see the next section for more details of this. Changing [url]http://www.aspalliance.com/[/url] to a Hyperlink To change [url=http://www.aspalliance.com/]AspAlliance.Com[/url] to a hyperlink with http://www.aspalliance.com/ as the URL and AspAlliance.Com as the anchor text (i.e. the HTML equivalent of a href= http://www.aspalliance.com/ AspAlliance.Com /a ) a more complex regular expression subsitution may be used: % InitialString = [url=http://www.aspalliance.com/]AspAlliance.Com[/url] Set RegularExpressionObject = New RegExp With RegularExpressionObject .Pattern = \[url=([^\]]+)\]([^\]]+)\[\/url\] .IgnoreCase = True .Global = True End With ReplacedString = RegularExpressionObject.Replace(InitialString, a href= $1 $2 /a ) Response.Write Replaced InitialString with: ReplacedString Set RegularExpressionObject = nothing % In this example, there are two sets of parenthesis which match the subpattern of the URL (i.e. http://www.aspalliance.com ) and the anchor text (i.e. AspAlliance.Com). These are accessible in the RegExp object's Replace method as $1 and $2, respectively. As mentioned previously, these patterns may be used in a different order to the way they were matched. They can also be used more than once. For example, this line adds additional HTML to include a title attribute for the a tag: ReplacedString = RegularExpressionObject.Replace(InitialString, a href= $1 title= Visit $2 ($1) $2 /a ) This replacement produces the HTML: a href= http://www.aspalliance.com/ title= Visit AspAlliance.Com (http://www.aspalliance.com/) AspAlliance.Com /a Useful Development Tools ASP Documentation Tool Automatically creates developer documentation for ASP 2.0 and 3.0 web applications written in VBScript and JScript. Documentation for Microsoft Access, SQL Server 7/2000 databases and Visual Basic 6.0 components associated with the web application can also be incorporated into the reports. Documentation is created in HTML, HTML Help and plain text formats. View Sample Output (HTML Help format). View Sample Output (HTML Format). Download Trial Version (5.2Mb ZIP file). Index Server Companion The Index Server Companion is a Windows application that extends the functionality of Microsoft Index Server so that it is able to index content from remote websites and also from ODBC databases. As such it can be used as a low cost alternative to Site Server 3.0 Search. View Product Documentation (119K ZIP file). Try Sample Search Facility . Download Trial Version (1.7Mb ZIP file). ASP.NET Documentation Tool Automatically creates developer documentation for ASP.NET web applications written in C# or VB.NET. Documentation for SQL Server 7/2000 databases and C#/VB.NET components associated with the web application can also be incorporated into the reports. Documentation is created in HTML, HTML Help and plain text formats. View Sample Output (HTML Help format). View Sample Output (HTML Format). Download Trial Version (727K ZIP file). SQL Documentation Tool The SQL Documentation Tool creates technical documentation for Microsoft SQL Server 7.0 and 2000 databases. Technical documentation is created in HTML and HTML Help formats. The HTML Help format documentation is fully searchable and cross referenced. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, Triggers and Table Relationships. View Sample Output (HTML Help format). View Sample Output (HTML Format). Download Trial Version (10.3Mb ZIP file). The Website Utility The Website Utility examines websites for errors and areas that need to be optimised for search engines by using a built in web crawling engine. Errors checked for include broken or moved hyperlinks, missing page titles and missing meta tags. It also generates HTML for use in creating website site maps (table of contents pages - like this one ), and is able to create both client-side JavaScript Search Engines and server-side ASP Search Engines for a website. View Sample Output (HTML Format). Download Trial Version (3Mb ZIP file). Text Workbench Text Workbench is a file search and replacement utility for text files and Microsoft Office documents. Make rapid file replacements on multiple files and folders full of files. Advanced replacement options include regular expressions support. It even works on remote file systems via FTP. A Regular Expression Laboratory allows advanced pattern matching and replacement expressions to be built and tested. This great utility will make your everyday development tasks much easier! Download Trial Version (3Mb ZIP file; you have the option to either install directly from this link or save the file for later installation). Author details Brett Burridge spent two years working in the University of Essex Computing Service, before moving to The Internet Applications Group in the Autumn of 1999, where he developed e-Business applications for a range of corporate clients and dot-com start ups. Brett is presently employed as an Internet developer and technical writer through his own company, Winnersh Triangle Web Solutions Limited . The company produces a number of innovative products, including the popular ASP Documentation Tool , the Index Server Companion , the ASP.NET Documentation Tool , the SQL Server Documentation Tool and The Website Utility . The company is also available for web application design and development at reasonable rates, primarily using Microsoft technologies (ASP, ASP.NET, Visual Basic, SQL Server) but also using open source technologies such as PHP, MySQL and Perl. Specialist services include development of search solutions using Microsoft's Index Server and Site Server 3.0 Search. As well as the ASPAlliance, Brett has written articles for Ariadne.ac.uk and ASPToday , and has contributed recipes to the ASP.NET Developer's Cookbook . links Outside web development, Brett is interested in digital photography (here's my photo gallery ), tropical fishkeeping and collecting contemporary works of art by artists such as Doug Hyde . Article history "VBScript Regular Expressions: Subexpression Substitutions" published on ASPAlliance.com on 28 October 2004. ASP Kitchen : Classic ASP Articles : VBScript Regular Expressions: Subexpression Substitutions
page content copyright Brett Burridge 1998 - 2004. |
| Image Alt Tags | ASPAlliance View Sample Output (HTML Help format) View Sample Output (HTML Format) Download Trial Version View Product Documentation Try Sample Search Facility Download Trial Version View Sample Output (HTML Help format) View Sample Output (HTML Format) Download Trial Version View Sample Output (HTML Help format) View Sample Output (HTML Format) Download Trial Version View Sample Output (HTML Format) Download Trial Version Download Trial Version of Text Workbench Winnersh Triangle Web Solutions - Quality web development at affordable prices Download a Free ASP Documentation Tool Now! Search Engine Builder - Build a search engine for your website! |
| Internal Links | http://authors.aspalliance.com/brettb/Default.asp (3 links in this page) [ Robot View of this URL ] http://authors.aspalliance.com/brettb/ClassicASPArticles.asp (3 links in this page) [ Robot View of this URL ] http://authors.aspalliance.com/brettb/TableOfContents.asp (2 links in this page) [ Robot View of this URL ] http://authors.aspalliance.com/brettb/ASP.NetArticles.aspx [ Robot View of this URL ] http://authors.aspalliance.com/brettb/Tools.asp [ Robot View of this URL ] http://authors.aspalliance.com/brettb/What'sNew.aspx [ Robot View of this URL ] http://authors.aspalliance.com/brettb/VBScriptRegularExpressions.asp [ Robot View of this URL ] http://authors.aspalliance.com/brettb/Links.asp [ Robot View of this URL ] http://authors.aspalliance.com/ [ Robot View of this URL ] |
Report generated by The Website Utility 2.8