I have a field 'ID' which has 7 digit number format eg. 1234512, 0234512, 0003456, 0000312.
I'm using an Input box & a Search button to add a functionality to search multiple IDs at a time.
InputBox is associated with var vID & 'Select in Field' action added added on button for 'ID' field with value ='('&replace(replace(vID, ',' ,''),' ', '|')&')' (User enters text "1234512, 0234512, 0003456 " which is converted in format "(1234512|0234512|0003456)"
Now, this works perfectly fine if user enters a 7 digit number. But, how can we modify this to search an ID without any leading zeros. eg, 1117,345 instead of 0001117,0000345