14,982
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 56: | Line 56: | ||
== 如何取代換行符號 == | == 如何取代換行符號 == | ||
支援 [[Regular expression]] 的文字編輯軟體 | |||
* 例: [[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> | |||
== Related articles == | == Related articles == | ||
| Line 64: | Line 69: | ||
* [http://violin-tao.blogspot.tw/2016/05/crlflf-bug.html 陳雲濤的部落格: 筆記 CRLF跟LF之區別 --- 隱形的 bug]:「CRLF才是真正的打字機運作方式，你可以想像：打字機打到最右邊，要先return到最左邊之後，再往下一行，所以是CRLF ... ...」 | * [http://violin-tao.blogspot.tw/2016/05/crlflf-bug.html 陳雲濤的部落格: 筆記 CRLF跟LF之區別 --- 隱形的 bug]:「CRLF才是真正的打字機運作方式，你可以想像：打字機打到最右邊，要先return到最左邊之後，再往下一行，所以是CRLF ... ...」 | ||
* [https://confluence.qps.nl/fledermaus/questions-answers/other/differences-in-end-of-line-characters-mac-windows-and-linux Differences in end of line characters Mac, Windows, and Linux] | * [https://confluence.qps.nl/fledermaus/questions-answers/other/differences-in-end-of-line-characters-mac-windows-and-linux Differences in end of line characters Mac, Windows, and Linux] | ||
References | References | ||