PAD - Parse Text Action - Use Excel functions to parse text not RegEx - Will help those of us that are not developers and know excel
So for example I want to use the Parse Text action to take a file name and parse it into three variables Date, Employee Last Name and Employee ID. I could do this super easy with LEFT(), RIGHT() as expressions to parse out the three variables... but a RegEx? I have no idea... It would definitely help those of us that are business analysts... and have no idea how to form a RegEx. Thanks!