Having comprehensive control of your files at any moment is vital to alleviate your everyday tasks and increase your productivity. Accomplish any goal with DocHub features for papers management and hassle-free PDF editing. Access, modify and save and incorporate your workflows along with other secure cloud storage.
DocHub gives you lossless editing, the opportunity to use any formatting, and securely eSign papers without the need of looking for a third-party eSignature software. Obtain the most of your document management solutions in one place. Consider all DocHub capabilities today with the free account.
In this video tutorial, Phil demonstrates methods for cleaning text strings, specifically focusing on extracting uppercase and lowercase letters as well as numbers. He introduces the use of the `text.remove` and `text.select` functions in Power Query to achieve these extractions. The tutorial is conducted in Excel, but the techniques can also be applied in Power BI by copying the query code. Starting with a table of random text strings, Phil guides viewers through opening Power Query, renaming the query to "text_select," and creating a custom column for lowercase letters using the appropriate code syntax.