blocks|key|409337|text|如果计算分号的数量对您来说已经足够了，那么可以在Perl中使用以下解决方案来计算分号的数量：Perl+FAQ+4.24:+How+can+I+count+the+number+of+occurrences+of+a+substring+within+a+string|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|409338|entityMap|0|LINK|mutability|MUTABLE|url|http://www.perl.com/doc/FAQs/FAQ/oldfaq-html/Q4.24.html^0|1A|2F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If counting the number of semicolons is good enough for you, you can do it in Perl using this solution: <a href="http://www.perl.com/doc/FAQs/FAQ/oldfaq-html/Q4.24.html" rel="nofollow noreferrer">Perl FAQ 4.24: How can I count the number of occurrences of a substring within a string</a>

blocks|key|3627974|text|我相信以下内容应该可以在Excel中使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3627975|=+Len(A1)+-+Len(Substitute(A1,+";",+""))+%2B+1|code-block|syntax|javascript|3627976|/EDIT:如果您已经将电子邮件地址粘贴到多个单元格中，则可以使用以下函数对单元格进行计数：|3627977|=+CountA(A1:BY1)|3627978|CountA对给定范围内的非空单元格进行计数。可以通过在单元格中键入=CountA(，然后用鼠标光标选择单元格范围来指定范围。|offset|length|style|CODE|BOLD|3627979|entityMap^0|0|0|0|0|0|6|Y|8|Y|8|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|X|8|@$M|Y|N|Z|O|P]|$M|10|N|11|O|P]|$M|12|N|13|O|Q]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|S|$]]

I believe the following should work in Excel:

<pre><code>= Len(A1) - Len(Substitute(A1, ";", "")) + 1
</code></pre>

/EDIT: if you've pasted the email addresses over several cells, you can count the cells with the following function:

<pre><code>= CountA(A1:BY1)
</code></pre>

<code>CountA</code> counts non-empty cells in a given range. You can specify the range by typing <code>=CountA(</code> into a cell and then selecting your cell range with the mouse cursor.

blocks|key|3628010|text|使用while循环遍历它并计算';‘可能是最快的，也是最易读的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3628011|考虑Konrad的建议，它也会遍历字符串，检查每个字符，看看它是否是一个符号，然后in修改字符串(可能是可变的，我不知道使用excel)，然后计算它和原始字符串之间的长度。|3628012|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

looping over it with a while loop and counting the ';' is probably going to be the fastest, and the most readable.

Consider Konrad's suggestions, that too will loop through the string and check every char and see if it is a simicolon, and then in modifies the string (may or may not be mutable, I don't know with excel), and then it counts the length between it and the original string.

blocks|key|4474505|text|如果您使用的是Excel，则可以使用此代码并公开它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4474506|Public+Function+CountSubString(ByVal+RHS+As+String,+ByVal+Delimiter+As+String)+As+Integer
++++Dim+V+As+Variant
++++V+=+Split(RHS,+Delimiter)
++++CountSubString+=+UBound(V)+%2B+1
End+Function|code-block|syntax|javascript|4474507|如果您有.NET，您可以创建一个小的命令行实用程序|4474508|Module+CountSubString

++++Public+Sub+Main(ByVal+Args()+As+String)

++++++++If+Args.Length+<>+2+Then
++++++++++++Console.WriteLine("wrong+arguments+passed->")
++++++++Else
++++++++++++Dim+I+As+Integer+=+0
++++++++++++Dim+Items()+=+Split(Args(0),+Args(1))
++++++++++++Console.WriteLine("There+are+"+&+CStr(UBound(Items)+%2B+1)+&+"+
++++++++End+If

++++End+Sub
End+Module|4474509|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you are using Excel you can use this code and expose it.

<pre><code>Public Function CountSubString(ByVal RHS As String, ByVal Delimiter As String) As Integer
 Dim V As Variant
 V = Split(RHS, Delimiter)
 CountSubString = UBound(V) + 1
End Function
</code></pre>

If you have .NET you can make a little command line utility

<pre><code>Module CountSubString

 Public Sub Main(ByVal Args() As String)

 If Args.Length &lt;&gt; 2 Then
 Console.WriteLine("wrong arguments passed-&gt;")
 Else
 Dim I As Integer = 0
 Dim Items() = Split(Args(0), Args(1))
 Console.WriteLine("There are " &amp; CStr(UBound(Items) + 1) &amp; " 
 End If

 End Sub
End Module
</code></pre>

blocks|key|409443|text|将列表加载到您最喜欢的位置(而不是记事本！)编辑器，替换；替换为\n，查看状态栏中有多少行，如果需要，删除最后一行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|409444|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Load the list in your favorite (not Notepad!) editor, replace ; by \n, see in the status bar how many lines you have, remove the last line if needed.

blocks|key|3628082|text|Bash/Cygwin一行程序|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3628083|$+echo+"user@domain.tld;user@domain.tld;user@domain.tld"+%7C+sed+-e+'s/;/\n/g'+%7C+wc+-l
3|code-block|syntax|javascript|3628084|如果你已经安装了Cygwin，它实际上是即时的。如果不是，cygwin值得安装IMHO。它基本上提供了一个覆盖在Windows系统上的Linux+bash提示符。|3628085|顺便说一句，这就是为什么我更喜欢*nix而不是Windows的原因，因为bash脚本比批处理脚本强大得多，没有Cygwin我就不能在windows机器上生活。|3628086|entityMap|0|LINK|mutability|MUTABLE|url|http://www.cygwin.com/^0|5|6|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

<h2>Bash/<a href="http://www.cygwin.com/" rel="nofollow noreferrer">Cygwin</a> One-Liner</h2>

<pre><code>$ echo "user@domain.tld;user@domain.tld;user@domain.tld" | sed -e 's/;/\n/g' | wc -l
3
</code></pre>

If you already have Cygwin installed it's effectively instant. If not, cygwin is worth installing IMHO. It basically provides a Linux bash prompt overlaid over your Windows system.

As an aside, stuff like this is why I prefer *nix over Windows for work stuff, I can't live on a windows box without Cygwin since bash scripts are so much more powerful than batch scripts.

blocks|key|1072355|text|带LINQ3.0的C#会让这一切变得简单，如果你是C%2B%2B的一种选择|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072356|myString.ToCharArray().Count(char+=>+char+=+';')|1072357|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

C# 3.0 with LINQ would make this easy if it is an option for you over C

myString.ToCharArray().Count(char => char = ';')

blocks|key|3628132|text|PowerShell：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3628133|>+$a+=+'blah;blah;blah'
>+$a.Split(';').Count++
3|code-block|syntax|javascript|3628134|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

PowerShell:

<pre><code>&gt; $a = 'blah;blah;blah'
&gt; $a.Split(';').Count 
3
</code></pre>

blocks|key|1072373|text|3)如果你既没有安装cygwin，也没有安装powershell，试试这个.cmd|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072374|@echo+off
set+/a+i+=+0
for+%25%25i+in+(name1@mail.com;name2@mail.com;name3@mail.com)+do+set+/a+i+=+i+%2B+1
@echo+%25i%25|code-block|syntax|javascript|1072375|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

3) if you don't have neither cygwin, nor powershell installed try this .cmd

<pre><code>@echo off
set /a i = 0
for %%i in (name1@mail.com;name2@mail.com;name3@mail.com) do set /a i = i + 1
@echo %i%
</code></pre>

blocks|key|4474635|text|如果是awk，则echo是可等待的(和it+is,+even+on+windows)：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4474636|echo+"addr1;addr2;addr3...."+%7C+awk+-F+";"+"{print+NF}"|code-block|syntax|javascript|4474637|entityMap|0|LINK|mutability|MUTABLE|url|http://gnuwin32.sourceforge.net/packages/gawk.htm^0|J|M|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

If awk, echo is awailable (and <a href="http://gnuwin32.sourceforge.net/packages/gawk.htm" rel="nofollow noreferrer">it is, even on windows</a>):

<pre><code>echo "addr1;addr2;addr3...." | awk -F ";" "{print NF}"
</code></pre>

I have a list of all email ids which I have copied from the 'To' field, from an email I received in MS Outlook. These values (email ids) are separated by a semicolon. I have copied this big list of email ids into Excel. Now I want to find the number of email ids in this list; basically by counting the number of semi colons.

One way I can do this is by writing C code. i.e. store the big list as string buffer, and keep comparing the chars to ";" in a <code>while(char == ';') loop</code>.
But I want to do it quickly.

Is there any quick way to find that out using either:

1.) Regular expression (I use powergrep for processing the regexps)

2.) In excel itself (any excel macro/plugin for that?)

3.) DOS script method

4.) Any other quick way of getting it done?

How can I find the count of semicolon separated values?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我有一个从“收件人”字段复制的所有电子邮件in列表，这些in来自我在MS Outlook中收到的一封电子邮件。这些值(电子邮件ids)用分号分隔。我已经将这个很大的电子邮件I列表复制到Excel中。现在我想要找出这个列表中的电子邮件in的数量；基本上是通过计算分号的数量。我可以这样做的一种方法是编写C代码。例如，将大列...

问如何找到分号分隔值的计数？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到分号分隔值的计数？EN