![]() ![]() ![]() The 3 main Regex formulas you can use on Google Sheets are: That’s right, I’m all about learning tools to make my life easier and lately Regex is my favourite. The good news is that you can use Regex on Google Sheets to work with your data, making your life beyond easy. You may be thinking “oh no, another complex programming language I don’t understand that complicates things even more”. It can be used on many platforms, such as Google Analytics, Python, Java, and more, to perform searches of specific strings. Regex is a matching expression tool returning specific values, for example, true or false, whether it finds the expression or not. Thanks to a recent outstanding presentation delivered by Robin Lord during a digital marketing Meetup event at Brainlabs, I was introduced to the world of Regex. They’ll do the work, but the time it takes to set them up makes me question whether I am actually working faster. Not only are they fundamental for my survival as an SEO analyst, But sometimes, these functions are just not good enough. On a regular basis, either in Google Sheets or Excel, I use formulas such as vlookup, index, iferror, and the list goes on, to sort quickly through endless data. Handling big sets of data to analyse is quite normal if you work in SEO. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |