Libreoffice Calc Advanced Filter With Regular Expressions

Опубликовано: 02 Ноябрь 2024
на канале: Sean Johnson

3,856

LibreOffice Calc Spreadsheet Advanced Filter Uses Regular Expressions.
In this tutorial, I show you how to use regular expressions with the LibreOffice Calc (spreadsheet) advanced filter to query spreadsheet data.
You can do query by example operations to find data that begins with or contains or ends with specific words or phrases.
You can also use the combination of the advanced filter with regular expressions to find or extract rows containing blank cells or rows excluding blank cells.

☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...
https://www.buymeacoffee.com/seanjohnson
☕

Advanced Filter Article that goes with this video (and download)
https://www.businessprogrammer.com/li...

Video Production
===============
📷 Sony Camera: https://amzn.to/3mqyqfu
Lens: https://amzn.to/3FU7KwB
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum

Microphones
---------------
🎤 Screen Casting: https://amzn.to/3a2TnHN
🎤 Microphone: https://amzn.to/2YXXPFx This is my latest mic, love it!
🎤 Talking To Camera: https://amzn.to/3FqXI6b

Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh

Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg

DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.