<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am using Microsoft Access.<br />
<br />
I need to parse a string which contains multiple lines.<br />
I would like to use Regex to <br />
1) Change all line feeds to &quot;##!##&quot;<br />
2) Remove all other non printing characters<br />
<br />
Thank you for you help.
</div>
</div>


Hi

I am using Microsoft Access.

I need to parse a string which contains multiple lines.
I would like to use Regex to 
1) Change all line feeds to "##!##"
2) Remove all other non printing characters

Thank you for you help.

Replace line feed with custom string , then remove all non printing characters in a string

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.