Excel Just Got NEW REGEX Functions You Need to Try!

Поделиться
HTML-код
  • Опубликовано: 25 ноя 2024

Комментарии •

  • @MyOnlineTrainingHub
    @MyOnlineTrainingHub  6 месяцев назад +11

    ❗NOTE❗These functions are currently available on the Microsoft 365 beta channel, so you may not see them in your version of Excel yet.

    • @nevermind2407
      @nevermind2407 3 месяца назад

      Stoked about this function, but not available yet for us mortals it seems...

  • @alisongunnels6240
    @alisongunnels6240 6 месяцев назад +7

    I am so glad to see REGEX in excel! Thank you for the video.

  • @hw7channel571
    @hw7channel571 6 месяцев назад

    Great update. Updating people about new features and function really helps, because softwares get updated usually without you knowing the tools and function newly added. Thanks for the videos

  • @JimFikes
    @JimFikes 6 месяцев назад +1

    It's about time that Excel added this. Thanks for another crystal clear explanation.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      Glad it was helpful!

    • @xbia1
      @xbia1 6 месяцев назад

      Indeed, OpenOffice and LibreOffice have regex as long as I remember.

  • @DingusBatus
    @DingusBatus 6 месяцев назад

    I don’t need/use the full power/capabilities of Excel at work, we just use as a basic base.
    But I do play around with Excel at home. I can see me using this once it’s available. I’ve only ever heard of REGEX but never actually seen it used, I’m looking forward to learning this.😀

  • @HandelMcHandel
    @HandelMcHandel 6 месяцев назад

    Looks great Mynda - probably not much use to me but good to know when/if the time comes! Thanks - I love learning new things even if no use to me!

  • @chrism9037
    @chrism9037 6 месяцев назад

    Saw these on Leila's channel too, can't wait to get these Mynda. They look really useful!

  • @adamnealis
    @adamnealis 6 месяцев назад

    Microsoft have resisted real regex support for decades. Very nice to see useful regex support.

  • @nevermore17011990
    @nevermore17011990 6 месяцев назад

    this is the formula that i sometimes use gg sheet then excel. goodjob MS

  • @tmb8807
    @tmb8807 6 месяцев назад

    This is fantastic, thanks. Now just need it in Power Query!

  • @henryg5735
    @henryg5735 6 месяцев назад +1

    Not got it yet 😪 but it should be useful and could hopefully save using PQ on occasion. Much as I am a PQ fan, and Pivot Tables for that matter, I find the need to refresh more and more annoying.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      I know what you mean. This video covers a few ways you can auto-refresh PivotTables: ruclips.net/video/1d3u3lmK1mQ/видео.html

    • @henryg5735
      @henryg5735 6 месяцев назад

      ​@@MyOnlineTrainingHub Thank you and it is useful from time to time, but nothing beats the instant "refresh" of formulas.
      I hoped I could do away with many pivot tables when pivotby & groupby came along, but the need to manipulate data first means that PQ & Pivot tables generally provide an easier & faster overall solution but with the need to refresh. I wonder if Regex can change that, although the syntax is a real problem for me at first sight; AI should help though. Or maybe someone will come along with a Regex GUI add-on.
      Your videos are great! Thank you.

  • @ianbennett148
    @ianbennett148 6 месяцев назад

    Only been waiting 30 years for this! Will Excel REGEX support positive/negative look behind/ahead?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад +1

      Great to hear, Ian. Yes, it supports positive/negative look behind/ahead. They use the PCRE2 library.

  • @patricknyamu6110
    @patricknyamu6110 6 месяцев назад

    Nice thanks

  • @sentralorigin
    @sentralorigin 6 месяцев назад +2

    there is a competitor Excel channel i also watch who dropped a similar video but i much prefer Mynda's

  • @stevenlwi1072
    @stevenlwi1072 6 месяцев назад

    Is possible to use Regextract to extract date from a string of text ?

  • @humansizedaperture
    @humansizedaperture 6 месяцев назад

    Can you place formulas WITHIN the regex pattern? Also, can the regex pattern handle references to arrays?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад +1

      Yes, as long as they return a text string. I haven’t tested whether the pattern can handle arrays but I doubt it because what would it do with the arrays…there’s only one input of text. 🤔

    • @MitchellAllen-h6u
      @MitchellAllen-h6u 5 месяцев назад

      For array references, you'll need to fire up VBA. First, go to tools> references and make a reference to Microsoft VBScript Regular Expression 5.5. Then, just iterate over the range OR, write your regex to handle all the text at once, which would require you to read the whole array into a string.

  • @andrewdove2303
    @andrewdove2303 6 месяцев назад +1

    Got so excited only to realise that I am not one of the chosen few!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад +1

      I know how you feel. It took me two PCs to find one with it, which is a lot less than the 7 it took to get Python! 😅

  • @Milhouse77BS
    @Milhouse77BS 6 месяцев назад

    Finally!

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 6 месяцев назад

    Any option that array functions could work inside the table as they throw #spill error

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      No. There are no plans to support spilled arrays inside Tables.

  • @rusektor
    @rusektor 6 месяцев назад

    Regex? Really? This is cool! ))) So, does it support non-backtracking, balancing groups, groups naming, options for modifying behavior on the way of the text? ))

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      Not sure as I'm not a RegEx expert, but I can tell you is uses the PCRE2 library if that helps.

    • @rusektor
      @rusektor 6 месяцев назад

      @@MyOnlineTrainingHub Yeah, I looked thru function description where it says that. Thanks! )

  • @paulvanobberghen
    @paulvanobberghen 6 месяцев назад

    I believe, the identifier part (before the @) of an email address may also include the underscore (_) and tilde (~) characters so I guess they also need to be inserted in the regex, shouldn't they?

  • @LuisWan-o7q
    @LuisWan-o7q 3 месяца назад

    I've been using this on google sheets for a while, but I still not getting the update on office.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  3 месяца назад

      It's still in beta testing. You'd need to be on the Office Insiders beta channel to get it. You can sign up for free to become an Office Insider.

  • @njzzb
    @njzzb 6 месяцев назад

    this function is not available on my office. I hope this function can be updated in the office soon.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      Yes, it's just been released in the beta version, so it'll be months before it's generally available. You can get the beta version for free by joining the Microsoft Insiders program: insider.microsoft365.com/en-us/join/windows

  • @GeertDelmulle
    @GeertDelmulle 6 месяцев назад

    WOW! This is so new, I’m still downloading the update…
    But, still, WOW! Very powerful, indeed.
    OK, caveat: now I need to learn about REGEX.
    Thanks for this Breaking News, Mynda! :-)

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад +1

      😁 so pleased you're excited about these new functions, Geert!

    • @rusektor
      @rusektor 6 месяцев назад +1

      You MUST learn it! It's cool and neat. )))

  • @akalarun
    @akalarun 6 месяцев назад

    I am using MS 365 - Beta Channel - Version 2406 -(Build 17716.20002) but this function is not available. Why?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      They only roll it out initially to 50% of devices. You can try another PC if you have one. It took me two goes this time but for python it took me 7!

  • @rusektor
    @rusektor 6 месяцев назад

    Sadly, they don't appear in functions list... 😪 (Version 2406 Build 16.0.17716.20002). EDIT: On another computer they DO appear!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      It took me two PCs to get them too 😅

    • @rusektor
      @rusektor 6 месяцев назад

      @@MyOnlineTrainingHub 🤣

  • @gibbousmoon35
    @gibbousmoon35 6 месяцев назад

    I won't have to import resources and write functions to get regex in Excel sheets? Oh, good news!

  • @montebont
    @montebont 6 месяцев назад +1

    30 years to late and the syntax makes absolutely no sense. A RE is an RE and is very well defined outside this "new"
    MS context. I'll stick with Sheets which follows well established standard;-)

  • @montebont
    @montebont 6 месяцев назад

    Amazing how people that call themselves data experts have never heard of RE...Where have they been since the late 1970's...?

    • @Mishkafofer
      @Mishkafofer 6 месяцев назад +1

      Excel became a data wrangling tool in the last couple of years. Until then, it was a limited modeling tool for business.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад +2

      @montebont, most data experts these days were probably not born until the 90s or later! 😆

    • @montebont
      @montebont 6 месяцев назад

      @@MyOnlineTrainingHub which means that they should know about RE's that have been around - and doing a perfect job - for at least 20 years...

    • @montebont
      @montebont 6 месяцев назад

      @@MyOnlineTrainingHub It's R&K stuff. If you don't now what that means...you're don't know the first thing about data processing...

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  6 месяцев назад

      I'm not sure where your original comment is aimed. Who said they never heard of RE?

  • @OzduSoleilDATA
    @OzduSoleilDATA 6 месяцев назад

    Very interesting. Kinda intimidating, too. 🫢
    Thanks for the video. I'm trying to get myself up to speed on these new functions.