Wild card lookup to update another field.

Question

Good Afternoon,

Hope everyone is doing well. I have an update statement that i believe to be very simple, but i just can't figure it out.

I have two fields [COMPANY], [DROPREASON].  See attached workflow.

Everytime the word "Fund" or "Trust" appears in the [COMPANY] field - i need to update the [DROPREASON] field with "08"

Its basically a wild card. I tried building the formula out using the CONTAIN tool but had no luck, then i tried the Find and Replace tool, but that updates the same field. Any thoughts?

WILD_CARD_HELP.yxmd

AbhilashR · Accepted Answer

Hi @jdelaguila, you could use the following formula to populate the DROPREASON field.

IF Contains([ICOMPANY],'Fund')
OR Contains([ICOMPANY],'Trust')
	THEN '08'
ELSE Null()
ENDIF

RobertOdera · Accepted Answer

Hi, @jdelaguila

Try this.

Please mark as solution + like, if it works for you.

Gave you both options.

The workflow is attached.

Cheers!