record("scalcout", "$(P)$(R)to_upper_1")
{
field("CALC", "AA{'a','A'}{'b','B'}...")
}
Though, with a maximum length of 80 characters, you'd only be able to get 8 replacements per record. You'd have to chain together a set of 4 of these records to make an entire string capitalized (and then another 4 records for lowercase).
record("luascript", "$(P)$(R)to_upper")
{
field("CODE", "return string.upper(AA)")
}
Hi,
Is there a way to convert a string from uppercase to lowercase or
vice-verse by using only available records within database files?
Best,
Han
|