Lookup Ignore Case

CloverDX Platform
1

I am using lookup function in Reformater component, however, some of my input data are in upper case and some are in lower case and some are in proper case. The value in my lookup table is all in proper case. Is there a way for lookup to ignore the case?

For example:
Input Value → “SURREY”, “surrey”
Value in the lookup → “Surrey”

Both two input values in this case should return a lookup value.

I know there is uppercase and lowercase function, but not sure if there is an ignorecase function?

2

Hi yichuansancun,

There is Aspell type of lookup in commercial versions. Setting 0 cost for “CASE”, 1 cost for rest of edit costs and threashold=1 would do the magic.

For free editions you must assure same lower/uppercase key values among all lookups.

I hope this helps.