Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I have an Input Box field and associated Search Button where users are able to input a list of Order ID's from a single Excel column (copy and paste of values) or a comma separated list and then click on Search for just those Order ID's.
The problem I have is that some Order ID's have two leading zeros, but not all Order ID's do. This is causing those Order ID's with leading zero's to not be "found". That's problem 1.
Problem 2, is I also get just a row with an Order ID with no other data after I manually strip any leading zeros.
Any idea how to, 1) Get rid of the leading zeros and allow the search and 2) Eliminate or populate the rows with just an Order ID?
It's not quite clear for me where the leading zeros are - within the search-list or within the qv field-values?
Both sides - searchvalue and fieldvalue - must have the same structure to get a match. I think this meant you need to enforce respectively adjust this structure - maybe by formatting the excel-values to a string (which meant they will keep leading zeros) or by loading the qv field purely numeric without leading zeros (maybe within an extra field and using this for the selection).
- Marcus
It's not quite clear for me where the leading zeros are - within the search-list or within the qv field-values?
Both sides - searchvalue and fieldvalue - must have the same structure to get a match. I think this meant you need to enforce respectively adjust this structure - maybe by formatting the excel-values to a string (which meant they will keep leading zeros) or by loading the qv field purely numeric without leading zeros (maybe within an extra field and using this for the selection).
- Marcus
Hello Marcus:
My apologies for the delay in replying. I've been out. Anyway, you are correct. It's a formatting problem within Excel. Fixed that and it works now. Thank you for the help.