replace multiple line breaks with one new line cha

2019-07-15 01:47发布

How to replace multiple line breaks with one new line charatcer in oracle server using REGEXP_REPLACE.

1条回答
在下西门庆
2楼-- · 2019-07-15 02:23

I think this is what you are after. Dealing with carriage returns can get tricky depending if you are on Windows or UNIX but you'll get the idea. This was run in Toad, which uses a regular expression which looks for occurrences of two or more newline characters in a row and replaces them with one newline.

enter image description here

查看更多
登录 后发表回答