Power Query - Fixed Pattern Extraction 🎾

Подписаться 3,1 тыс.

Просмотров 1,4 тыс.

50% 1

In this Video i show you how to extract a Fixed Pattern from a Dataset 🎾
#dataanalytics #data #datatransformation #etl #powerbi #powerquery #mquery #excel #exceltips
File
github.com/jbotes/powerbiTuto...
M Query Book
www.amazon.com/Definitive-Gui...
Noteworthy techniques
- Custom Function
Functions Used
Text.Remove
powerquery.how/text-remove/
list.select
powerquery.how/list-select/
text.split
powerquery.how/text-split/
text.length
powerquery.how/text-length/

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@nyamdulamnyamjav9700 20 дней назад

Life saver

@jorstube Месяц назад

Una maravilla de Función 🎉🎉🎉🎉❤❤❤

@boissierepascal5755 Месяц назад

Great !

@rangs1966 Месяц назад

Super

@tonybatty504 Месяц назад

Enjoyed the video, some interesting steps.

@basensei8699 Месяц назад

thanks Tony!

@kebincui Месяц назад

Another great video 👍. Thanks James

@basensei8699 Месяц назад

thank you!

@williamarthur4801 Месяц назад

Ok, I may have only been following along, and just about understand the logic, but oh, the sense of amazement when I clicked ok and it worked. 😊😊

@basensei8699 Месяц назад

Glorious!

@qasimawan3569 Месяц назад

Love these videos, keep them coming!

@RonDavidowicz Месяц назад

I’m not sure when I’d use this, but another great video. Can you please explain the 2 Text.remove statements?

@basensei8699 Месяц назад

Hey Ron! yes indeed so with a Reference like ABC1234567. The first remove statement takes the first 3 characters "ABC" and it removes charcters that are in "A" to "Z" in this case all three are in the range so the result = "" (blank). TRUE. If we put JaMeS into it it would have returned "a" and that would be "" so false.

@basensei8699 Месяц назад

so it returns a TRUE of the characters match. if it doesnt match then it returns FALSE and it's not part of the pattern.

@patrickyoung2106 Месяц назад

Most excellent!

@corradoagnoletto905 15 дней назад

It is easier and faster with REGEXEXTRACT function in excel using the pattern "[A-Z]{3}[0-9]{7}"

@williamarthur4801 Месяц назад

BTW , how about a follow up on the nested custom functions, there's not much out there, also i must get Ricks and what's her names book. I think you and he should to a video together, it would be an interesting contrast in style. 😋😋

@basensei8699 Месяц назад

Ye that would be great idea - that book is next level. They really went all out with that one. Might be a good collab! and thanks for that content idea on nested custom functions! was wondering what to do next :)