Button to clear expression

[#1]

I have an input box where you can enter a range of Shipment ID's (separated by commas) and a 'Go'  button to search on the inputed values. I also have a 'Clear' button to clear the selection. This all works fine, but the previous Shipment IDs searched still shows up in the input field (even though the selection is cleared). Is there a way to clear the expression, and not just the selection?

My 'Go' button is a 'Select in Field' action:

='('&replace(ShipmentID,',','|')&')'

My 'Clear'button is just a 'Clear All' field. Does anyone have any suggestions?

[#2]

Hi Rebeccad,

You can use this function in Go button Action:

='('&replace(trim(VProdID),'  ','|')&')'

Please see the attached qvw. You just need to copy Ids from excel and past them in input box.

Hope this help,

Anosh

[#3]

That worked! Thanks!!