Home › Forums › kdb+ › Transform Specific Column Values › Re: Transform Specific Column Values
-
Thank for your suggestions rocuinneagain I’ll definitely try to adapt them in my context but please note that we can neither assume a 4-character root or the first non-capital letter as a suffix.
Instead, do you think that the SSR function might work? That is actually the challenge somehow go over each data line for each conversion line pattern matching in the most optimized way.