I have used this video on multiple extractions with various modifications with a different pattern! Thank you so much! Great videos as always. Short, quick and to the point! In my opinion, you are the Inside Edition of Power Query on UA-cam!
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.
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. 😋😋
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 :)
I have used this video on multiple extractions with various modifications with a different pattern! Thank you so much! Great videos as always. Short, quick and to the point! In my opinion, you are the Inside Edition of Power Query on UA-cam!
Great videao
Awesome Video
Thanks!
Una maravilla de Función 🎉🎉🎉🎉❤❤❤
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. 😊😊
Glorious!
Another great video 👍. Thanks James
thank you!
Enjoyed the video, some interesting steps.
thanks Tony!
Super
Love these videos, keep them coming!
Most excellent!
I’m not sure when I’d use this, but another great video.
Can you please explain the 2 Text.remove statements?
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.
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.
Great !
👏
Life saver
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. 😋😋
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 :)
how do you extract a a number pattern with "/" and number (eg. 1234554/1, 1334535/2) using your example?
It is easier and faster with REGEXEXTRACT function in excel using the pattern "[A-Z]{3}[0-9]{7}"