Identifying Values in Alphabetical Range

[Acnelson312]

Hi guys, 

So I am trying to utilize Alteryx to identify values that fall into an alphabetical range. I'd like to get an output of a list that can possibly be grouped by an identifier. 

To start I'd have a list of items (there could be 100 or could be 100,000) that can be possibly values given out. The list could have any combination that begins with letters, and have numbers in it. 

Example:

Combination1

Comb124

Combo1

Combin

ACombo1242

bigcombo421

figure01

test102k

etc....

Then I'd have a range that I want to Identify which of those values would fall into it. So if I am given a range A-B, I'd get all the ones starting with A up to starting with B. (ACombo1242, bigcombo421).

A-F would return:

Combination1

Comb124

Combo1

Combin

ACombo1242

bigcombo421

figure01

Any ideas on how I should approach this? Any help would be much appreciated. 

Thanks!

[CharlieS · Accepted solution]

@Acnelson312

I built a macro that will accomplish this task. Connect this macro and select the field you'd like to filter based on the first letter. Then enter two letter for the filter range. Let me know if you have any questions.

[ponraj]

Attaching a sample workflow for your case....

[CharlieS]

@ponraj

Awesome use of "CharToInt" and "CharFromInt".

[MarqueeCrew · Accepted solution]

@Acnelson312,

Sorry that I am late to the party, but I'm going to demonstrate my love for Regular Expressions here:

REGEX_Match([Input], "[A-D].*")

This filter is looking for anything that begins with the letter A, B, C or D.

If I wanted to look for A-D or 1-4, then it would be:

REGEX_Match([Input], "[A-D1-4].*")

Cheers,

Mark

[Acnelson312]

Some great approaches to solving this and I appreciate it! I am still working through it, but will be using a mix of the first and third solution. Much thanks!