Problem with IntervalMatch() function

[#1]

Hi community.

Please i have a problem with a function IntervalMatch().

I would like to adapt this function to match alphabetic

I have attached a sample application that I made.

But I realize that the mapping does not work.

Would you give me an idea to solve this problem?

Best regards.

[disqr_rm]

Intervalmatch() only works on numeric data. What you can do is assign a numeric value to your data using DUAL() function and then you can use intervalmatch.

[#3]

Please could you give me an example ...?

Thx

[disqr_rm]

Idea would be you assign 1-26 to A-Z and z-z, then for each value in your range you convert them to a number. Example: ABC becomes 123. Using LOAD dual('ABC', 123) as Value will give you Value display in Text but it will internally store as 123. Then you should be able to IntervalMatch() on it.

Just an idea for you to take next steps.

OK, I will also try to build one for you.

[#5]

Thanks sir.

But I do not see the thing without the example

OK

[#6]

Please are there IntervalMatch function () which does not resume as numerical values​​?
Thank you.