By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Enter line feed in Search+Replace?

P: n/a
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
Jan 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Michael Peters" <mp@michaelpeters.de> wrote in message
news:dq*************@news.t-online.com...
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

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
Jan 12 '06 #2

P: n/a
> The update queries would look something like that below
thanks Anthony, looks good, I'll try that.
-Michael
Jan 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.