Optim

Using Affinity Provider in LUA

  • 1.  Using Affinity Provider in LUA

    Posted 10 days ago
    Hello,

    I'm trying to use LUA to take a substring of my column value and mask it using the Affinity provider, but I must be missing how to pass the value of the substring to the call.

    Example:
    Source Value = ABCD12345999

    I want to perform a substring function to get the value "12345" from the source value.  I accomplish that by doing:
    myString = string.sub("ABCD12345999", 5, 9)

    Result:
    myString = 12345

    Next:
    How do I construct the Affinity call to use "myString" as the source?

    Thank you,
    Trong

    ------------------------------
    Trong Bo
    Senior Environment Administrator
    HealthNow New York
    ------------------------------