Count occurrences of a word in string - Revision history

Planetoid at 11:26, 5 September 2025

2025-09-05T11:26:26Z

← Older revision		Revision as of 19:26, 5 September 2025
Line 164:		Line 164:
	<references />		<references />

	[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] [[Category:Data transformation]] [[Category:MySQL]]		[[Category: Software]]
			[[Category: Programming]]
			[[Category: Data Science]]
			[[Category: String manipulation]]
			[[Category: Data transformation]]
			[[Category: MySQL]]
			[[Category: Revised with LLMs]]

Planetoid: /* BASH */

2025-09-05T11:25:32Z

BASH

@@ Line 59: / Line 59: @@
 * (4) execute the following command {{kbd | key=<nowiki>sort <file.txt> | uniq -ic | sort -nr</nowiki>}}<ref>[https://unix.stackexchange.com/questions/134446/counting-the-occurrences-of-the-string text processing - Counting the occurrences of the string - Unix & Linux Stack Exchange]</ref><ref>[https://unix.stackexchange.com/questions/170043/sort-and-count-number-of-occurrence-of-lines Sort and count number of occurrence of lines - Unix & Linux Stack Exchange]</ref>
 * (5) Remove the leading whitespace in the file: Using the [[Text editor with support for regular expression | text editor]] with support for [[Regular expression|regular expression]] and replace {{kbd | key=<nowiki>^\s+(\d+)\s+</nowiki>}} with {{kbd | key=<nowiki>\1\t</nowiki>}}
 file: test.txt
@@ Line 70: / Line 73: @@
 </pre>
-=== Output format I: occurrence & keyword ===
+==== Output format I: count followed by keyword ====
 {{exclaim}} The term each line in the input file was allowed contains whitespaces.
@@ Line 92: / Line 95: @@
 </pre>
+==== Output format II: keyword followed by count ====
 {{exclaim}} The term each line in the input file should '''not''' contains whitespaces.
@@ Line 115: / Line 117: @@
 </pre>
 === Verification of count occurrence ===

Unknown user: /* References */

2023-02-15T04:32:18Z

References

← Older revision		Revision as of 12:32, 15 February 2023
Line 127:		Line 127:
	* {{kbd \| key=<nowiki>-i</nowiki>}} means {{kbd \| key=<nowiki>Ignore uppercase vs. lowercase.</nowiki>}}		* {{kbd \| key=<nowiki>-i</nowiki>}} means {{kbd \| key=<nowiki>Ignore uppercase vs. lowercase.</nowiki>}}
	* {{kbd \| key=<nowiki>-w</nowiki>}} means {{kbd \| key=<nowiki>--word-regexp</nowiki>}}		* {{kbd \| key=<nowiki>-w</nowiki>}} means {{kbd \| key=<nowiki>--word-regexp</nowiki>}}

			== Further reading ==
			* [http://stackoverflow.com/questions/12344795/count-the-number-of-occurences-of-a-string-in-a-varchar-field mysql - Count the number of occurences of a string in a VARCHAR field? - Stack Overflow] {{access \| date = 2016-09-21}}
			* [https://www.got-it.ai/solutions/excel-chat/excel-tutorial/conditional-formatting/most-frequently-occurring-text Excel formula: Most frequently occurring text - Excelchat]

	== References ==		== References ==
	* [http://stackoverflow.com/questions/12344795/count-the-number-of-occurences-of-a-string-in-a-varchar-field mysql - Count the number of occurences of a string in a VARCHAR field? - Stack Overflow] {{access \| date = 2016-09-21}}		<references />

	[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] [[Category:Data transformation]] [[Category:MySQL]]		[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] [[Category:Data transformation]] [[Category:MySQL]]

Unknown user: /* Excel */

2022-02-04T09:58:15Z

Excel

← Older revision		Revision as of 17:58, 4 February 2022
Line 3:		Line 3:
	== Excel ==		== Excel ==

	If ~~the cell value~~ was allowed ~~multiple values~~		If multiple values was allowed in a single cell
	* Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]<ref>[https://errerrors.blogspot.com/2022/02/excel-calculate-text-occurrence.html Excel 計算文字出現次數]</ref>. Or		* Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]<ref>[https://errerrors.blogspot.com/2022/02/excel-calculate-text-occurrence.html Excel 計算文字出現次數]</ref>. Or

	If ~~the cell value~~ was NOT allowed ~~multiple values~~		If multiple values was '''NOT''' allowed in a single cell
	* Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]		* Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]

Unknown user: /* Excel */

2022-02-04T09:55:46Z

Excel

← Older revision		Revision as of 17:55, 4 February 2022
Line 2:		Line 2:

	== Excel ==		== Excel ==
	# Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]<ref>[https://errerrors.blogspot.com/2022/02/excel-calculate-text-occurrence.html Excel 計算文字出現次數]</ref>. Or
	# Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]		If the cell value was allowed multiple values
			* Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]<ref>[https://errerrors.blogspot.com/2022/02/excel-calculate-text-occurrence.html Excel 計算文字出現次數]</ref>. Or

			If the cell value was NOT allowed multiple values
			* Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]

	== MySQL way ==		== MySQL way ==

Unknown user: /* Excel */

2022-02-04T09:54:32Z

Excel

← Older revision		Revision as of 17:54, 4 February 2022
Line 2:		Line 2:

	== Excel ==		== Excel ==
	# Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]. Or		# Using the function [https://support.office.com/zh-tw/article/substitute-%E5%87%BD%E6%95%B8-6434944e-a904-4336-a9b0-1e58df3bc332 SUBSTITUTE] & [https://support.office.com/zh-hk/article/len%E3%80%81lenb-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN] functions. [https://docs.google.com/spreadsheets/d/1eg5XuGs8X7bS_RrFECx8ktuPgTwpV12UPfkdlpbHlMU/edit?usp=sharing demo]<ref>[https://errerrors.blogspot.com/2022/02/excel-calculate-text-occurrence.html Excel 計算文字出現次數]</ref>. Or
	# Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]		# Using the function [https://support.office.com/zh-hk/article/countif-%E5%87%BD%E6%95%B8-e0de10c6-f885-4e71-abb4-1f464816df34 COUNTIF]

Unknown user: /* BASH */

2021-03-18T03:40:43Z

BASH

← Older revision		Revision as of 11:40, 18 March 2021
Line 67:		Line 67:

	=== Output format I: occurrence & keyword ===		=== Output format I: occurrence & keyword ===
	{{exclaim}} The term each line was allowed contains whitespaces.		{{exclaim}} The term each line in the input file was allowed contains whitespaces.

	Result of the execution of command: {{kbd \| key=<nowiki>sort test.txt \| uniq -ic \| sort -nr</nowiki>}} {{exclaim}} case insensitive		Result of the execution of command: {{kbd \| key=<nowiki>sort test.txt \| uniq -ic \| sort -nr</nowiki>}} {{exclaim}} case insensitive
Line 90:		Line 90:

	=== Output format II: keyword & occurrence ===		=== Output format II: keyword & occurrence ===
	{{exclaim}} The term each line should '''not''' contains whitespaces.		{{exclaim}} The term each line in the input file should '''not''' contains whitespaces.

	Result of the execution of command: {{kbd \| key=<nowiki>sort test.txt \| uniq -ic \| sort -nr \| awk ' { t = $1; $1 = $2; $2 = t; print; } '</nowiki>}} <ref>[https://stackoverflow.com/questions/11967776/swap-two-columns-awk-sed-python-perl Swap two columns - awk, sed, python, perl - Stack Overflow]</ref>{{exclaim}} case insensitive		Result of the execution of command: {{kbd \| key=<nowiki>sort test.txt \| uniq -ic \| sort -nr \| awk ' { t = $1; $1 = $2; $2 = t; print; } '</nowiki>}} <ref>[https://stackoverflow.com/questions/11967776/swap-two-columns-awk-sed-python-perl Swap two columns - awk, sed, python, perl - Stack Overflow]</ref>{{exclaim}} case insensitive

Unknown user: /* BASH */

2021-03-18T03:38:08Z

BASH

@@ Line 66: / Line 66: @@
 </pre>
-Result of the execution of command: {{kbd | key=<nowiki>sort test.txt | uniq -ic | sort -nr</nowiki>}} {{exclaim}} insensitive
+=== Output format I: occurrence & keyword ===
 <pre>
 #Apple
@@ Line 75: / Line 78: @@
 </pre>
-Result of the execution of command: {{kbd | key=<nowiki>sort test.txt | uniq -c</nowiki>}} {{exclaim}} sensitive
+Result of the execution of command: {{kbd | key=<nowiki>sort test.txt | uniq -c</nowiki>}} {{exclaim}} case sensitive
 <pre>
 #Apple
@@ Line 85: / Line 88: @@
 </pre>
-verification of count occurrence
 <pre>
 cat test.txt | grep -i "#apple$" | wc -l

Unknown user: Text replacement - "Category:Text file processing" to "Category:String manipulation"

2021-03-09T11:30:50Z

Text replacement - "Category:Text file processing" to "Category:String manipulation"

← Older revision		Revision as of 19:30, 9 March 2021
Line 100:		Line 100:
	* [http://stackoverflow.com/questions/12344795/count-the-number-of-occurences-of-a-string-in-a-varchar-field mysql - Count the number of occurences of a string in a VARCHAR field? - Stack Overflow] {{access \| date = 2016-09-21}}		* [http://stackoverflow.com/questions/12344795/count-the-number-of-occurences-of-a-string-in-a-varchar-field mysql - Count the number of occurences of a string in a VARCHAR field? - Stack Overflow] {{access \| date = 2016-09-21}}

	[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:~~Text file processing~~]] [[Category:Data transformation]] [[Category:MySQL]]		[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] [[Category:Data transformation]] [[Category:MySQL]]

Unknown user: /* BASH */

2020-09-22T11:05:05Z

BASH

← Older revision		Revision as of 19:05, 22 September 2020
Line 52:		Line 52:
	* (1) separate each string by [[Return symbol \| return_symbol]] <ref>[https://www.unix.com/shell-programming-and-scripting/83076-replacing-commas-newlines-using-sed.html replacing comma's with newlines using sed]</ref>		* (1) separate each string by [[Return symbol \| return_symbol]] <ref>[https://www.unix.com/shell-programming-and-scripting/83076-replacing-commas-newlines-using-sed.html replacing comma's with newlines using sed]</ref>
	* (2) check the [https://www.computerhope.com/unix/uuniq.htm uniq command] is exists on Cygwin of {{Win}} or {{Linux}}		* (2) check the [https://www.computerhope.com/unix/uuniq.htm uniq command] is exists on Cygwin of {{Win}} or {{Linux}}
	* (3) execute the following command {{kbd \| key=<nowiki>sort <file.txt> \| uniq -ic \| sort -nr</nowiki>}}<ref>[https://unix.stackexchange.com/questions/134446/counting-the-occurrences-of-the-string text processing - Counting the occurrences of the string - Unix & Linux Stack Exchange]</ref><ref>[https://unix.stackexchange.com/questions/170043/sort-and-count-number-of-occurrence-of-lines Sort and count number of occurrence of lines - Unix & Linux Stack Exchange]</ref>		* (3) (optional) input the command {{kbd \| key=<nowiki>export LC_ALL='C'</nowiki>}} on Cygwin of {{Win}} if met the error message "Invalid or incomplete multibyte or wide character" after input the following {{kbd \| key=<nowiki>sort</nowiki>}} command
	* (4) Remove the leading whitespace in the file: Using the [[Text editor with support for regular expression \| text editor]] with support for [[Regular expression\|regular expression]] and replace {{kbd \| key=<nowiki>^\s+(\d+)\s+</nowiki>}} with {{kbd \| key=<nowiki>\1\t</nowiki>}}		* (4) execute the following command {{kbd \| key=<nowiki>sort <file.txt> \| uniq -ic \| sort -nr</nowiki>}}<ref>[https://unix.stackexchange.com/questions/134446/counting-the-occurrences-of-the-string text processing - Counting the occurrences of the string - Unix & Linux Stack Exchange]</ref><ref>[https://unix.stackexchange.com/questions/170043/sort-and-count-number-of-occurrence-of-lines Sort and count number of occurrence of lines - Unix & Linux Stack Exchange]</ref>
			* (5) Remove the leading whitespace in the file: Using the [[Text editor with support for regular expression \| text editor]] with support for [[Regular expression\|regular expression]] and replace {{kbd \| key=<nowiki>^\s+(\d+)\s+</nowiki>}} with {{kbd \| key=<nowiki>\1\t</nowiki>}}

	file: test.txt		file: test.txt