Return symbol: Difference between revisions

(12 intermediate revisions by the same user not shown)

Line 111:

== 如何尋找與取代換行符號 ==

=== 文字編輯軟體如何取代換行符號 ===

* 支援 [[Regular expression]] 的文字編輯軟體，例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號) | 將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號)]]

=== MySQL 如何尋找換行符號 ===

Line 148:

Line 153:

</pre>

=== Excel 或 Google Sheet 如何尋找換行符號 ===

判斷是哪種換行符號：

<pre>

=IF(ISNUMBER(SEARCH(CHAR(13)&CHAR(10), A1)), "CRLF (\r\n)",

IF(ISNUMBER(SEARCH(CHAR(13), A1)), "CR (\r)",

IF(ISNUMBER(SEARCH(CHAR(10), A1)), "LF (\n)",

"無換行符號")))

</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>.

=== ~~文字編輯軟體如何取代換行符號 ==~~=

函數說明

* ~~支援 [[Regular expression]] 的文字編輯軟體，例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單~~ (~~取代換行符號為逗號~~) | ~~將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號~~)]]

* {{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

~~=== Excel 如何取代換行符號 ===~~

函數說明

* {{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>[\r\n]</nowiki>}} 符合任意類型的換行符號

* {{kbd | key=<nowiki>=TRIM(SUBSTITUTE(SUBSTITUTE(A1, CHAR(13),""), CHAR(10),", ")</nowiki>}} to replace the return symbol 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=<nowiki>[\r\n]+</nowiki>}} 符合任意類型的換行符號，出現一次或連續出現

** {{kbd | key=CHAR(10)}} means "Line feed" which equal to {{kbd | key=<nowiki>\n</nowiki>}}

** {{kbd | key=CHAR(13)}} means "Carriage return" which equal to {{kbd | key=<nowiki>\r</nowiki>}}

=== Python 如何取代換行符號 ===

Line 176:

Line 196:

[[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]]

[[Category: Programming]]

[[Category: Data Science]]

[[Category: String manipulation]]

[[Category: Revised with LLMs]]

@@ Line 111: / Line 111: @@
 == 如何尋找與取代換行符號 ==
+=== 文字編輯軟體如何取代換行符號 ===
+* 支援 [[Regular expression]] 的文字編輯軟體，例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號) | 將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號)]]
 === MySQL 如何尋找換行符號 ===
@@ Line 148: / Line 153: @@
 </pre>
+=== Excel 或 Google Sheet 如何尋找換行符號 ===
+判斷是哪種換行符號：
+<pre>
+=IF(ISNUMBER(SEARCH(CHAR(13)&CHAR(10), A1)), "CRLF (\r\n)",
+  IF(ISNUMBER(SEARCH(CHAR(13), A1)), "CR (\r)",
+    IF(ISNUMBER(SEARCH(CHAR(10), A1)), "LF (\n)",
+      "無換行符號")))
+</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>.
-=== 文字編輯軟體如何取代換行符號 ===
+函數說明
-* 支援 [[Regular expression]] 的文字編輯軟體，例: [[Regular expression#將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號) | 將Email清單，轉成Email軟體可以使用的寄信名單 (取代換行符號為逗號)]]
+* {{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
-=== Excel 如何取代換行符號 ===
+函數說明
-* {{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>[\r\n]</nowiki>}} 符合任意類型的換行符號
-* {{kbd | key=<nowiki>=TRIM(SUBSTITUTE(SUBSTITUTE(A1, CHAR(13),""), CHAR(10),", ")</nowiki>}} to replace the return symbol 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=<nowiki>[\r\n]+</nowiki>}} 符合任意類型的換行符號，出現一次或連續出現
-** {{kbd | key=CHAR(10)}} means "Line feed" which equal to {{kbd | key=<nowiki>\n</nowiki>}}
-** {{kbd | key=CHAR(13)}} means "Carriage return" which equal to {{kbd | key=<nowiki>\r</nowiki>}}
 === Python 如何取代換行符號 ===
@@ Line 176: / Line 196: @@
 <references />
-[[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]]
+[[Category: Programming]]
+[[Category: Data Science]]
+[[Category: String manipulation]]
+[[Category: Revised with LLMs]]