Power Query - Fixed Pattern Extraction 🎾

Рет қаралды 2,222

BA Sensei

Күн бұрын

Пікірлер: 25

@seninallou2388 3 ай бұрын

Great videao

@Bhavik_Khatri 2 ай бұрын

Awesome Video

@basensei8699 2 ай бұрын

Thanks!

@qasimawan3568 7 ай бұрын

Love these videos, keep them coming!

@tonybatty504 7 ай бұрын

Enjoyed the video, some interesting steps.

@basensei8699 7 ай бұрын

thanks Tony!

@kebincui 7 ай бұрын

Another great video 👍. Thanks James

@basensei8699 7 ай бұрын

thank you!

@jorstube 7 ай бұрын

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

@nyamdulamnyamjav9700 6 ай бұрын

Life saver

@patrickyoung2106 7 ай бұрын

Most excellent!

@RonDavidowicz 7 ай бұрын

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

@basensei8699 7 ай бұрын

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 7 ай бұрын

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.

@rangs1966 7 ай бұрын

Super

@seninallou2388 3 ай бұрын

👏

@williamarthur4801 7 ай бұрын

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 7 ай бұрын

Glorious!

@boissierepascal5755 7 ай бұрын

Great !

@seninallou2388 3 ай бұрын

how do you extract a a number pattern with "/" and number (eg. 1234554/1, 1334535/2) using your example?

@williamarthur4801 7 ай бұрын

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 7 ай бұрын

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 :)