I need to lookup & display records that have text anywhere in the Description field from PO details.

I am using a formula: FINDANY({detDescription} ,"steel", "iron", ”brass” ) = 1

Everything is working nicely. But now I have two questions:

1. The text I look for can be anywhere in the Description field.
How can I display in a separate column the text of the look-up word that we are searching for? (e.g. Display the text: “Steel”, “Iron”, “Brass” in a separate GV column)

2. I may need to lookup about 10-20 items.
Is there a more appropriate method to lookup this data?

Hi Samuel,

This is a perfect use-case for TABLEFIND(). Take a look at the Help text for the function and there should be an example workspace TABLEFIND.GVS in \Softrak\gvwin\Views,

Ask more questions if this isn't enough explanation.

Thank you, Andrew. I will check it out and let you how this works out.

Andrew: What am I missing?
I am looking at the GV Workspace "Tablefind.gvs". It opens two views.
Nowhere (at least what I see) is there a column/field/formula that is using TABLEFIND().

Hi Samuel,

The TABLEFIND() function is used in the Filter of the TABLEFIND View.