Regular expression and ....

[Moe]

I asked this question last week but so far it remains unanswered (or it was
answered some where that I can not find.)
I need to modify the content of a "memo field" by searching for a "number
followed by a period like "1."" and then adding a new line before the number.
Otherwords,
creating numbered lines out of a very long memo. I do not know if "new line"
character can be added in a memo field in access or not. If it can be done
then what would be the vba code to do this?
Moe

 

[hmadyson]

In order to ener the line break you need to use Chr(13) & Chr(10)

I am not sure how to search for regular expressions in VBA, but you can use
instr to find the location of specific text and then concatenate the string
around the line break.

Let me know if this was helpful and if you can use more assistance.

 

[John Nurick]

The rgxReplace() function at
http://www.j.nurick.dial.pipex.com/Code/index.htm can be used in an
Access query.

Use an expression like this in an update query, where XXX is the field
name:

rgxReplace([XXX], "(\d+\.\s)", Chr(13) & Chr(10) & "$1")