Using Regex formula for device detection in WooCommerce orders before export

[Bjorn.drivn]

Hey @Anze , interesting case and good question!

So first of all I would say there is an easier option to do this: Create a new sheet or new tab and use the IMPORTRANGE() or the QUERY() function. This will import the data and you should be able to filter without messing up the formula.

RegEx in make

However since Make provides you with great power and more extensibility it would also be a good idea to use this. You can use a regex match pattern module to extract all information.

^(?<browser1>.+?) \((?<os>.+?)\)(?: (?<engine>\S+(?: \(.+?\))?)(?: Version\/(?<version>\S+(?: Mobile\/\S+)?))?(?: (?<browser2>\S+))?(?: \S+? (?<browser4>\S+\/\S+$))?)?

You can test and check the groups of this specific pattern in Regex101 for debugging and learning:

regex101: build, test, and debug regex

More information to learn about regex you can find here as well:

How to use Regex in Make?

Last updated: 2024/14/01 In regular cases it’s very usefull to use Regex (or Regular Expressions) if you want to extract or replace data in some text. When there always is a similar pattern in your text data, regex is ideal to use. But how can you use regex? Table of content 1 – What is regex 2 – How to begin with RegEx 3 – Starting development 4 – Basics - Extracting data from text 5 – Basics - Replacing data with the replace() function 6 – Basics - Named capturing groups 7 – Advanced -…