Return symbol: Difference between revisions

Return symbol (edit)

214 bytes added , 24 May 2018

15,041

edits

@@ Line 56: / Line 56: @@
 == 如何取代換行符號 ==
-支援 [[Regular expression]] 的文字編輯軟體
+* 支援 [[Regular expression]] 的文字編輯軟體，例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號) | 將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號)]]
-* 例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號) | 將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號)]]
+* MySQL: {{kbd | key=<nowiki>SELECT REPLACE(REPLACE(REPLACE(`column`,'\r\n',''),'\n',''),'\r','') </nowiki>}} <ref>[https://stackoverflow.com/questions/13273343/replace-new-line-character-in-mysql-not-working sql - REPLACE new line character in MYSql not working - Stack Overflow] </ref>
+* Excel: [https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/ 3 ways to remove carriage returns in Excel: formulas, VBA macro, find&replace dialog] {{access | date = 2018-05-24}}
-MySQL
-* {{kbd | key=<nowiki>SELECT REPLACE(REPLACE(REPLACE(`column`,'\r\n',''),'\n',''),'\r','') </nowiki>}} <ref>[https://stackoverflow.com/questions/13273343/replace-new-line-character-in-mysql-not-working sql - REPLACE new line character in MYSql not working - Stack Overflow] </ref>
 == Related articles ==