Drop the selection PharmacyName that appears under the field PharmacyName

[Anonymous]

I know it's possible to remove PharmacyName from the Listbox alone, but i need to use this field other places.
So it would work best if I dropped it in the script I think.

[#2]

select 'expression' in the 'Field' dropdown list of the list box object and type in:

if(PharmacyName<>'PharmacyName',PharmacyName)

[Anonymous]

will this just drop it from the listbox?

If I use the field PharmacyName in a chart will PharmacyName appear as a selection?,

[#4]

yes, only from the listbox

[Anonymous]

I want to drop it from everything. How can I do that?

[sivarajs · Accepted solution]

try this in script

load *

from filepath

where substringcount(PharmacyName,'PharmacyName')=0;

[Anonymous]

Perfect, thank you