Range of alphabets between two list box

[#1]

Hi,

I want to display range of alphabets between two alphabets selected in list boxes

example : I have two listboxes From and To ,  If I select 'A' in From listbox and 'E' in To listbox then  result should display ABCDE in table

[sunny_talwar]

May be using this:

=Concat(Chr(Ord(From) + ValueLoop(0, Ord(To)-Ord(From))))

[Clever_Anjos]

PFA a not optimized solution

[#4]

Hi,

I do not want to concatenate the selected values in range ,  I want to show the data in report between selected alphabets range

example data in report should show between values 'A' to 'E'

[Clever_Anjos · Accepted solution]

Please try this instead

[MarcoWedel]

Hi,

another solution using alternate states, set expressions and sample data from your thread listbox from and to date might be:

LOAD *,
    Money(Rand()*100) as sales
INLINE [
    StoreLocCode
    RPOS1
    L01RF
    34GEF
    9C3B
    BDF21
    BS040
    DWKS008
    TR97GH
    4TYRS
];

hope this helps

regards

Marco

[#7]

will it work for alphanumeric values?

example

If user enter From value  '13l1A'  and To value '14D1A ' in the input box  and then click on button then below  mentioned values should be selected as green in below Listbox

Values should selected as green:

13I1A            

13I2A            

13I2B           

14D1A

Listbox:

13H1B            

13I1A            

13I2A            

13I2B           

14D1A           

15D2A           

15H1A           

15H3A           

20C6A            

20D6B            

[MarcoWedel]

Your initial question was how to reduce a table based on selections in two list boxes.

Selecting field values based on inputs in input boxes is another question.

Please clarify.

thanks

regards

Marco