Splitters
On the other hand, splitters perform the task of dividing a single text value into multiple distinct components. Whether separating full names into first and last names or dissecting a complete address into individual elements, they can break a string apart into more granular pieces. This principle is also relevant in transformation scenarios where previously merged column values need to be separated. Splitters provide a means to reverse the merging process, separating values back into their original distinct components at a subsequent stage in the data transformation process.
In the Power Query M language, splitters are used to separate a string into a list of text values based on a specific delimiter or pattern. These are often utilized by higher-order standard library functions such as Table.SplitColumn, which is designed to divide a single column into multiple columns or rows. This is a common operation frequently used when handling strings that require parsing or...
