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?
Answers
Best Answer
lorren answered 9 years ago
lorren answered 9 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
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