Show data based on Alphanumeric range

[#1]

Hi,

I want to display selected data in listbox which consist of alphanumeric values  based on values provided in input box

example I have below data with listbox LOCN and input box for From and To values with button

if user enters '1A2A' in From and '1A4A' in To and click on button then below values in LOCN listbox should be selected and data show in the report accordingly  only for selected values

Data:

LOCN	RTN
1A1A	1023
1A1A	1027
1A1A	1028
1A2A	3123
1A2A	3124
1A2A	3289
1A3A	3290
1A4A	2111
1A4A	2312
1B1A	4421
1B1B	1245
1B1B	1287
1B2A	4231
1B2B	7652
1B3A	1628

Values selected in LOCN listbox

1A2A

1A3A

1A4A

[nagarjuna_kotha]

I guess for combination of text and number data we can not filter on From and To.

Instead u u can use Input Box

Example:

Copy values from Excel or some other place and Paste in Input Box  and thrn Select

It will give selected values only

[nagarjuna_kotha]

Check attched,

Export your data to excel and Copy some and paste those it Input Box and press enter and then Select Filter.

It will select those you have entered by you.

I hope this may helps you.

-Nagarjun

[#4]

there should be two inputs From and To not one

[nagarjuna_kotha]

For alfanumaric its not possible i thisnk.

This kind of scenario we require only one.

Check attached

-Nagarjun

[marcus_sommer]

I think you will need to translate your alphanumerical values into unique numerical values and then you could apply a numeric range-matching from - to. For this you could create a new field like:

...

rangesum(

num(mid(LOCN, 1, 1)) * 100000 * ord(mid(LOCN, 2, 1)),

num(mid(LOCN, 3, 1)) * 100 * ord(mid(LOCN, 4, 1))) as LOCN_Numeric

...

There could be some more logic be needed to ensure that each LOCN creates an unique number and it's order regarding to the expected ranges is correct - but the approach itself should work.

- Marcus