Regex Tools

Tags: Calc Extensions

last edited: 2023-01-24

Rating:

This extension aims to provide Calc functions using Regex.

Description

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!

Homepage: https://github.com/vmalep/LORegExAdd-In

Release List

Release: 0.1.0 – First publication of this extension.