Power Query - Create a "Super" TRIM Function (plus cool trick)
Автор: BCTI
Загружено: 2025-03-14
Просмотров: 6283
Learn, step-by-step, how to remove leading, trailing, and internal redundant spaces from text using Power Query. Also, learn the process for converting a query into a reusable, custom function that can be applied to individual columns in a table or to the entire table with a simple table transformation trick.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:49 Using Power Query's TRIM Function
02:10 Overview of the Project Objectives
02:52 Overview of the Needed Functions
03:16 Split Text by Spaces
04:33 Replace Empties with NULLs
06:22 Filtering Out the NULLs
07:20 Combine the Remaining Text
08:14 Creating a Single-Step Solution
10:50 Creating a Reusable Function
14:50 Reusing the Function
15:31 Applying a Function to an Entire Table
16:38 Project Wrapup
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
