Tags: Calc Extensions
This extension aims to provide Calc functions using Regex.
For the moment, there is only one function, regextract, that extract caracters from a string according to a regex pattern. It contains 3 parameters: the string to search into, the pattern in which each group to be extracted is put into brackets, and the number of the group to be displayed. I.e: regextract("12 abc 12";"(\d+)\s(\D+)";1) = 12 and regextract("12 abc 12";"(\d+)\s(\D+)";2) = abc
Special thanks to Lorenzo Carbonell who helped me debugging this extension!