Most Effective method to group records by letter?

Hi,

I have a field with letters A-Z in it. I want to split my data into four "buckets"

A-F
G-L
M-R

S-Z

I recognize that I can call out every single option in a SWITCH statement, or write a REGEX_MATCH for each of these, but is there a smarter way to handle a problem like this?

The particular function that I can't seem to reliably create is some sort of "Position in Alphabet". Is this something that exists which I just haven't found?

Output

Parse

Common Use Cases

Best Practices

Accepted answers

Bob_Blackey

Here's one way -

You could use the formula tool and the formula (with the example column "letter")

CharToInt([Letter])-64

which give you the position.

You could then use the Tile tool to set up the groupings.

All comments

Bob_Blackey

Here's one way -

You could use the formula tool and the formula (with the example column "letter")

CharToInt([Letter])-64

which give you the position.

You could then use the Tile tool to set up the groupings.

Claje

Ah - I think what I was missing is the need to normalize the data.

I tried that and was getting inconsistent results, not thinking of the fact that A/a would naturally have different integer values.

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703