求助大神幫忙做一下歌曲分詞和詞頻的統計。
具體格式參考圖片中的第一條《天使的翅膀》后新增欄位分詞和分詞頻次。基本就是這個樣子
感覺應該可以使用某個程式泡跑一下，但是我不會寫程式啊
所以請求各位大神路過寫個程式幫一下忙。非常感謝！！！！！
uj5u.com熱心網友回復：
分詞用“|”豎線隔開，例：你|美麗|
Public Function WordFrequency(ByVal Lyric As String, ByVal Word As String) As String
Dim arr As Variant
Dim brr As Variant
Dim i As Long
Dim countChar As Long
If Lyric = "" Or Word = "" Then Exit Function
If InStrRev(Word, "|") = 0 Then Exit Function
arr = Split(Word, "|")
For i = 0 To UBound(arr) - 1
brr = Split(Lyric, arr(i))
countChar = UBound(brr) - LBound(brr)
WordFrequency = WordFrequency & "“" & arr(i) & "”" & "出現次數：" & countChar & vbCrLf
Next i
End Function
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/62346.html
標籤：Access
上一篇：用C#開發軟體，查詢資料量大時，報錯Fatal error encountered during command execution
下一篇：4個表的復雜聯合查詢，求助！