I do not know if this works on a memo field, so it may not.
<string expression> is the field that you are searching.
Do one character replacement at a time with the special characters. Once you get it working that way then experiment with getting them working together.
so an example would be REPLACE (Notes, char(13), char(13))
you do not need the start, end or count like you thought.
The character that is being imported may not be a CR/LF you might want to take and copy/paste the field value into Word and look at the text with the paragraph marks on, this is how I found out what the characters I needed to remove where.
Hope this helps to clear things up.
<string expression> is the field that you are searching.
Do one character replacement at a time with the special characters. Once you get it working that way then experiment with getting them working together.
so an example would be REPLACE (Notes, char(13), char(13))
you do not need the start, end or count like you thought.
The character that is being imported may not be a CR/LF you might want to take and copy/paste the field value into Word and look at the text with the paragraph marks on, this is how I found out what the characters I needed to remove where.
Hope this helps to clear things up.
