Memo objects are large strings that allow formatting and whitespace characters, such as line feeds and Tab characters. They use the same methods and attributes as the String data type. See Strings.


For methods such as matches or replace that use Java regular expressions, you can construct regular expressions to identify formatting characters in memo fields. For example, return"\R", ". ") replaces the line separators in the PLN.Formula property with a period and then a space, which converts this:
Screenshot shows memo field with three lines separated by line separators

to this:

Screenshot shows formula field with the three lines separated by a period and a space.