Skip to content
+1-888-319-3663

COMMUNITY FORUM

Translation Table From – Case Sensitive?

chadbruels asked 7 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?
Answers
Best Answer
lorren answered 7 years ago
Chad,

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.