koala icon indicating copy to clipboard operation
koala copied to clipboard

Add support for SUBSTITUTE

Open todhunter opened this issue 5 years ago • 0 comments

Could be great with support for the SUBSTITUTE function. I was able to get the substitute to work by adding the substitute function to koala/excellib.py

def substitute(*args):
    if tuple(flatten(args)) != args:
        return ExcelError('#VALUE', 'Could not process arguments %s' % (args))

    cat_string = str(args[0]).replace(str(args[1]), str(args[2]))

    return cat_string

todhunter avatar Jul 24 '20 09:07 todhunter