Features       Ask DevGuru       ASP Resources       Find the Bug       Knowledge Base       Links       Tips of the Week       Tutorials   Products       dgCalendar       dgCharge New!       dgChart New!       dgFileUpload       dgReport New!       dgSort       dgTree   Site       Authoring       Coming Soon       DevGuru Resume       Link to Us       Merchandise       Sponsorships       Testimonials       What's New   Technologies       ADO 2.6       ASP       CSS2       HTML       JavaScript       Jet SQL       Transact-SQL Syntax       VBScript       WML       WMLScript       WSH       XML DOM                All Functions Filter Function FUNCTION:  Replace( ) Replace(String, FindSubstring, ReplaceSubstring, Start, Count, Compare)   The Replace function replaces a specified substring within a specified string with a new specified substring and returns the modified string.   There are three mandatory arguments.   String   The String argument is the string to be searched.   FindSubstring   The FindSubstring argument is the substring you are searching for inside the string.   ReplaceSubstring   The ReplaceSubstring argument is the the new substring string that you wish to insert inside the string.   Code: <% =Replace("How now brown cow?", "brown", "purple") %>   Output: How now purple cow?   There are three optional arguments.   Start   The optional Start argument specifies the position number, counting from the left, where you wish to start the search.   Note that the portion of the string to the left of the start position will be discarded.   Code: <% =Replace("How now brown cow?", "brown", "purple", 7) %>   Output: w purple cow?   Count   The optional Count argument specifies how many times to replace the substring.   Code: <% =Replace("red blue red-blue redblue bluered", "blue", "purple", 1, 3) %>   Output: red purple red-purple redpurple bluered   Compare   The optional Compare argument must only use either the constant or value of the COMPARISON CONSTANTS.   CONSTANT VALUE DESCRIPTION VBBinaryCompare 0 Binary comparison VBTextCompare 1 Text Comparison VBDataBaseCompare 2 Compare information inside database   In the example, by using VBBinaryCompare, or 0, for the Compare argument, all upper/lower case differences are obeyed in both the search and replace.   Code: <% =Replace("red blue red-blue redblue bluered", "BLUE", "PURPLE", 1, 3, 0) %>   Output: red blue red-blue redblue bluered   In the example, by using VBTextCompare, or 1, for the Compare argument, all upper/lower case differences are ignored in the search and obeyed in the replace.   Code: <% =Replace("red blue red-blue redblue bluered", "BLUE", "PURPLE", 1, 3, 1) %>   Output: red PURPLE red-PURPLE redPURPLE bluered Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information