Power Query Excel | M CODE - Text.Split/SplitAny vs Splitter.SplitByDellimiter/SplitByAnyDelimiter

This video will explain the Text.Split, Text.SplitAny, Splitter.SplitByDelimiter, Splitter.SplitByAnyDelimiter functions with a simple example. Those functions are crucial for data transaction.
Topic:
0:20 - Overview
0:51 - Example 1: Non-M Code transformation
1:51 - Explain the difference between Text.Split and Splitter Functions.
3:47 - Example 2: M Code Transformation
Topic useful to understand some of the functions in the video:
N/A
Workbook:
docs.google.co...

[@kebincui]

Excellent video, very clearly explained ❤👍🌹. Looking forward to more videos like this about Power Query

[@roywilson9580]

Thanks for an interesting video on the splitter functions. I thought that you explained the functions very well.

[@bsmart2gether408]

Hi Roy, Thank you for your compliments ☺️

[@roywilson9580]

@@bsmart2gether408 You are welcome

[@مسلم_سني_مسلم]

As always, it's very well done.

[@bsmart2gether408]

Thank you, Adel 😊

[@مسلم_سني_مسلم]

@@bsmart2gether408 you are welcome

[@mirrrvelll5164]

This was a good one! Very useful!
I got one suggestion for one video, could you make something like match and count all the text values from one string if I have a separate table with unique values?
to expand this more:
Imagine you got one table with Column A that has longer text strings as you do now, and I want to extract only one instance from that string but use another table with those uniques. I used fuzzy merge on like 0.5 on similarity threshold but as you can imagine, data loss can be a problem =)

[@bsmart2gether408]

Thank you, mirrr velll. Do you have a list of texts that you want to search from the Column A? Or you are thinking of removing duplication of repeated texts. I am trying to visualise your case.

[@mirrrvelll5164]

@@bsmart2gether408 YES exactly, I do have another list which I would like to use as "match" table.

[@bsmart2gether408]

Great!! One more thing ro check. What is the expected outcome (I.e. a list, table, or return match value?)

[@mirrrvelll5164]

@@bsmart2gether408 Hmm good question, I guess match values would be fine. I am imagining it like that because you can filter it using slicers if blank or any other value than expected.

[@bsmart2gether408]

I'll think through some examples. The next topic is DAX related, so I'll cover it in the one after the next one.

[@Sumanth1601]

Excellent

[@bsmart2gether408]

Thank you Sumanth 😊