Skip to content


Translation Table From – Case Sensitive?

chadbruels asked 9 years ago
Is the From column for a translation table case sensitive? I want to create a "dummy proof" translation table so my client can make a spelling error on a type column and have a high probably that the translation will still work. So things like ( INV, INVOICE, inv, invoice, INVS) will all translate to the number 3. Do I need to include a row for both INV and inv?
Best Answer
lorren answered 9 years ago

Yes, the Translation Table is case sensitive so you need one row for INV and one for inv.

The other option is to write a calculated field using .NET and either a Case statement of if-then.

Something like this

If _MYCOLUMN.ToUpper() = "INV" then
 return 3
end if

If you would like to submit an answer or comment, please sign in to the eOne portal.