Thank you David.
Slava
>>What is the best practice of text merges? Can VB.Net/SQL procedures merge the text? Does anybody have an example of merging a text with a function's result?
>
>In the Community Starter Kit for ASP.NET (
http://www.asp.net/StarterKits) there is an example of merging and emailing a newletter to subscribers. Here is the pertinent code:
>
> //*********************************************************************
> //
> // FormatContentText Method
> //
> // Formats email text with content specific information.
> //
> //*********************************************************************
>
> public static string FormatContentText(string text, MailFormat bodyFormat) {
> string matchText;
>
> // Replace new articles
> matchText = Regex.Escape("<NewArticles>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Article"), bodyFormat));
>
> // Replace new events
> matchText = Regex.Escape("<NewEvents>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Event"), bodyFormat));
>
> // Replace new books
> matchText = Regex.Escape("<NewBooks>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Book"), bodyFormat));
>
> // Replace new links
> matchText = Regex.Escape("<NewLinks>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Link"), bodyFormat));
>
> // Replace new downloads
> matchText = Regex.Escape("<NewDownloads>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Download"), bodyFormat));
>
> // Replace new photos
> matchText = Regex.Escape("<NewPhotos>");
> if (Regex.IsMatch(text, matchText))
> text = Regex.Replace(text, matchText, FormatContentCollection(ContentPageUtility.GetNewContent("Photo"), bodyFormat));
>
> return text;
> }
>>
>This is not the same as FoxPro's ability to evaluate and execute a string but it would be easy to follow this approach and simply replace the token Today with System.DateTime.Now.ToString.
