Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Regex Syllables, Harlan Grove?
Good Morning, I am not very sofisticated when it comes to these
things,is there a way to count syllables using regex. If I had the word "understand" in A1 I would like it to return 3. I need to do this for a reader reliablility formula that I am working on. Any help would be greatly appreciated. Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Regex Syllables, Harlan Grove?
I can't help you with regex, but you could use the following user-defined
function to count the vowels in a cell: Public Function CountVowels(TxtIn As String) As Long Dim x As Long CountVowels = 0 For x = 1 To Len(TxtIn) Select Case UCase(Mid(TxtIn, x, 1)) Case "A", "E", "I", "O", "U" CountVowels = CountVowels + 1 Case Else 'do nothing End Select Next x End Function This code should be palced in a general VBA module in your workbook. You would call it like this (enter as a formula in a cell): =CountVowels(A1) If you are new to user-defined functions (macros), this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, Hutch "PJ" wrote: Good Morning, I am not very sofisticated when it comes to these things,is there a way to count syllables using regex. If I had the word "understand" in A1 I would like it to return 3. I need to do this for a reader reliablility formula that I am working on. Any help would be greatly appreciated. Thanks in advance! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Regex Syllables, Harlan Grove?
Not sure that helps with a word like "house".
Tom Hutchins wrote: I can't help you with regex, but you could use the following user-defined function to count the vowels in a cell: Public Function CountVowels(TxtIn As String) As Long Dim x As Long CountVowels = 0 For x = 1 To Len(TxtIn) Select Case UCase(Mid(TxtIn, x, 1)) Case "A", "E", "I", "O", "U" CountVowels = CountVowels + 1 Case Else 'do nothing End Select Next x End Function This code should be palced in a general VBA module in your workbook. You would call it like this (enter as a formula in a cell): =CountVowels(A1) If you are new to user-defined functions (macros), this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, Hutch "PJ" wrote: Good Morning, I am not very sofisticated when it comes to these things,is there a way to count syllables using regex. If I had the word "understand" in A1 I would like it to return 3. I need to do this for a reader reliablility formula that I am working on. Any help would be greatly appreciated. Thanks in advance! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Regex Syllables, Harlan Grove?
PJ wrote...
Good Morning, I am not very sofisticated when it comes to these things,is there a way to count syllables using regex. If I had the word "understand" in A1 I would like it to return 3. I need to do this for a reader reliablility formula that I am working on. Any help would be greatly appreciated. Thanks in advance! Can't do this with regular expressions. Since most languages using single phoneme alphabets (e.g., Latin, Cyrillic, Greek, Arabic) have no consistent rules with regard to dividing words into syllables, there's no alternative to looking up words in a dictionary list to determine the number of syllables. The dictionary list would need to look something like the the foobar foo bar banana ba na na that is, the word in the first field, the syllables in the subsequent fields, so the number of syllables equals the number of fields in the matching record less one. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Regex Syllables, Harlan Grove?
On Apr 30, 12:58*pm, Harlan Grove wrote:
PJ wrote... Good Morning, I am not very sofisticated when it comes to these things,is there a way to count syllables using regex. If I had the word "understand" in A1 I would like it to return 3. I need to do this for a reader reliablility formula that I am working on. Any help would be greatly appreciated. Thanks in advance! Can't do this with regular expressions. Since most languages using single phoneme alphabets (e.g., Latin, Cyrillic, Greek, Arabic) have no consistent rules with regard to dividing words into syllables, there's no alternative to looking up words in a dictionary list to determine the number of syllables. The dictionary list would need to look something like the * * the foobar *foo * * bar banana *ba * * *na * * *na that is, the word in the first field, the syllables in the subsequent fields, so the number of syllables equals the number of fields in the matching record less one. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hi, Harlan Grove, ? about negative time formula | Excel Worksheet Functions | |||
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) | Excel Worksheet Functions | |||
Harlan Grove PULL Code Help Please | Excel Worksheet Functions | |||
PULL function (Harlan Grove) - can it use Named Ranges? | Excel Worksheet Functions | |||
# of Functions per cell >> for Harlan Grove | Excel Worksheet Functions |