Enter line feed in Search+Replace?

is there a way to replace a certain sequence of characters by line feed
(vbCrLf ), for all text columns in a table, using Search+Replace?

-Michael

re: Enter line feed in Search+Replace?

"Michael Peters" <mp@michaelpeters.de> wrote in message
news:dq5ouq$ue6$03$1@news.t-online.com...[color=blue]
> is there a way to replace a certain sequence of characters by line feed
> (vbCrLf ), for all text columns in a table, using Search+Replace?
>
> -Michael[/color]


No, you would have to write the code yourself, or manually carry out update
queries on the text fields. The update queries would look something like
that below:

UPDATE MyTable SET MyTable.MyField=
Replace([MyField],"<NewLine>",Chr$(13) & Chr$(10),1,-1,1)
WHERE InStr(1,[MyField],"<NewLine>",1)>0

re: Enter line feed in Search+Replace?

> The update queries would look something like that below


thanks Anthony, looks good, I'll try that.


-Michael