You’re offline. This is a read only version of the page.
I feel like this has to have a really simple solution that I'm overlooking, but I just can't figure it out. I'm looking for a way to count how many times a letter occurs in a string; for example, "animal" would return "2", if I was counting the letter A.
I got it:
Here's the code to copy:
CountIf(Split(TEXT_FIELD, ""), Len(Value(ThisRecord.Value)) > 0)
Here's what it does:
1. The TEXT_FIELD that you want to search for numbers is split by each character
2. Each record's value (in this case, every character) is converted into a number
a. If it's already a number, this will return the character
b. If it's any character other than a number, it will be a blank record
3. The length of each character as a value is checked. If it's a number, this will return a 1. If it was another character that is now a blank record, this will return a 0.
4. Every 1 in this list is counted, returning you the number of numbers in your text field
My explanation might be a little confusing, but if you plug in the Split code into a list box it will help it make sense.
Ah, I see now that I did the result backwards lol. Glad you got the answer!
Something like this may work for that:
I like your way better, there's less code to reference it later on. Thanks!
@cmitchener This code will give the result seen below,
Share
Report
All responses (
Answers (
ClearCollect(colCharacterCount,
DropColumns(
AddColumns(
GroupBy(
Split("animal", ""),
"Value",
"GroupedValues"
)
,
"Count", CountRows(GroupedValues)
), "GroupedValues"
)
)
Please remember to give a đź‘Ť and accept my solution as it will help others in the future.
I figured a solution out, and since I haven't seen a great resource on it yet here's what I've found:
#1
WarrenBelz
250
Most Valuable Professional
#2
MS.Ragavendar
126
#3
stampcoin
115
