This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Substring( function will return the remainder of the string that occurs after the "|" character, which leaves "|||'01_2015$'". This can then be wrapped with a Trim( function to remove the unwanted characters ("|$`").
Check out the attached workflow to see this in action.
i didn't test this reply but think that it will run 3x as fast as the regex.
I've always thought this as well, because of the complex way that Regex scans and parses strings. So I did test it and the results are interesting. 1M, 10M and 100M rows using the methods from @MarqueeCrew(FileGetExt), @CharlieS(Substring) and myself(Regex)
As Mark conjectured, the native string functions used in Charlie's solution do run ~3 times faster than my Regex based solution. But what's happening with Mark's method. It's avoiding Regex, using the FileGetExt() function, but it's run time is on par with the Regex sol'n and 3 times slower than the String based formula. Strange! Of course, this could be explained if FileGetExt() uses Regex internally to perform its magic.