15,076
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
m
→如何尋找與取代換行符號
m (→如何尋找與取代換行符號) |
|||
| (10 intermediate revisions by the same user not shown) | |||
| Line 153: | Line 153: | ||
</pre> | </pre> | ||
=== Excel | === Excel 或 Google Sheet 如何尋找換行符號 === | ||
判斷是哪種換行符號： | 判斷是哪種換行符號： | ||
<pre> | <pre> | ||
| Line 169: | Line 161: | ||
"無換行符號"))) | "無換行符號"))) | ||
</pre> | </pre> | ||
=== Excel 或 Google Sheet 如何取代換行符號 === | |||
For Microsoft Excel or Google Sheet | |||
* {{kbd | key=<nowiki>=CLEAN(A1)</nowiki>}} Use the CLEAN function to "remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from the text"<ref>[https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41 CLEAN function]</ref>. Meanwhile, the return symbol will be removed from the text. | |||
* {{kbd | key=<nowiki>=TRIM(SUBSTITUTE(SUBSTITUTE(A1, CHAR(13),""), CHAR(10),", ")</nowiki>}} replace the return symbols with spaces in the cell located at {{kbd | key=A1}} <ref>[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}}</ref><ref>[https://en.wikipedia.org/wiki/ASCII ASCII - Wikipedia]</ref>. | |||
函數說明 | |||
* {{kbd | key=CONCAT(CHAR(13), CHAR(10))}} means "CRLF"({{kbd | key=<nowiki>\r\n</nowiki>}}) Windows 標準換行符號 | |||
* {{kbd | key=CHAR(13)}} means "Carriage return"(CR, {{kbd | key=<nowiki>\r</nowiki>}}) 舊版 Mac 換行符號 | |||
* {{kbd | key=CHAR(10)}} means "Line feed" (LF, {{kbd | key=<nowiki>\n</nowiki>}}) Unix/Linux 換行符號 | |||
For Google Sheet | |||
* {{kbd | key=<nowiki>=REGEXREPLACE(A1, "[\r\n]+", " ")</nowiki>}} replaces return symbols with spaces in cell {{kbd | key=A1}} in Google Sheets | |||
函數說明 | |||
* {{kbd | key=<nowiki>[\r\n]</nowiki>}} 符合任意類型的換行符號 | |||
* {{kbd | key=<nowiki>[\r\n]+</nowiki>}} 符合任意類型的換行符號，出現一次或連續出現 | |||
=== Python 如何取代換行符號 === | === Python 如何取代換行符號 === | ||
| Line 187: | Line 196: | ||
<references /> | <references /> | ||
[[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] | [[Category: Programming]] | ||
[[Category: Data Science]] | |||
[[Category: String manipulation]] | |||
[[Category: Revised with LLMs]] | |||