Find Replace without Secondary Table

Question

I'm wondering if there's a way to do a Find Replace (lookup) without having a secondary input data source.

For example, is there a tool I can use to enter in the values I'm looking for and the corresponding replacement values?

The worst case solution I thought of was simply to use a bunch of conditional functions to do this, but I assume there is an easier way :)

Thanks a bunch!

MarqueeCrew · Accepted Answer

@stphnwl,

Why wouldn't you want to read the lookup values from a metadata file?

The FIND & REPLACE can use a Text Input tool where you hand-type the values into this table (stored within the workflow).  That is likely the best option.  Here are some coding options:

1.  Use a SWITCH function: Shown with a default and 2 possible values

Switch([Variable],"Default","Value1","Value 1 Description", "Value 2", "Value 2 Description)

2. Use an IF statement (default + 2 possible values)

IF
   [Variable] = "Value1"   THEN "Value 1 Description"   ELSEIF
   [Variable] = "Value 2"   THEN "Value 2 Description"
ELSE
   "Default"
ENDIF

3. You can use a join, but that is more work than Find & Replace because the data will be sorted and if the value isn't found then you will need to union the Join with the Left data to get all of your records.

Hopefully the text input will suffice for the secondary input.

Cheers,

Mark