Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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
there should be two inputs From and To not one
For alfanumaric its not possible i thisnk.
This kind of scenario we require only one.
Check attached
-Nagarjun
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