Getting full power over your documents at any moment is vital to ease your daily duties and enhance your productivity. Accomplish any objective with DocHub tools for document management and hassle-free PDF editing. Access, adjust and save and integrate your workflows along with other secure cloud storage services.
DocHub provides you with lossless editing, the possibility to work with any format, and securely eSign documents without having looking for a third-party eSignature option. Obtain the most from the document management solutions in one place. Consider all DocHub features today with the free of charge account.
In this video tutorial, Phil demonstrates how to clean up text strings by extracting both uppercase and lowercase letters as well as numbers. He also introduces a method to remove a variety of characters from strings using the text.remove and text.select functions in Power Query. Although the tutorial is conducted in Excel, the same query code can be applied in Power BI. The process starts with a table containing random text strings. Phil instructs viewers to access Power Query by clicking into the table, renaming the query to "text_select" (since dots are not permitted in the name), and creating a new custom column for lowercase letters using the code: text.select(column_name, list_of_characters).
