Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)

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

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

  • @LeilaGharani
    @LeilaGharani  4 месяца назад +27

    Download the Excel workbook and Regex cheat sheet: pages.xelplus.com/regex-excel-file
    Note: These functions are currently available to some users in the beta channel for Microsoft Insiders. Please be patient as they (often very slowly) roll out to all Office 365 users.

    • @joerperson
      @joerperson 4 месяца назад +1

      Can I use this function to extract first name, middle initial, and last name from a range where not all records have a middle initial?

    • @haashini10031985
      @haashini10031985 4 месяца назад

      Thanks so much Leila.

    • @fellzer
      @fellzer 4 месяца назад

      Must be in Excel online.
      Pass.

    • @somebody767
      @somebody767 4 месяца назад

      ​@@joerpersonHello joerperson,
      I have crafted the following regex for you:
      \b(\p{Lu}\p{Ll}+)\s((?:(?:\p{Lu}(?:\.?\s?)*)\s?)*)(\p{Lu}\p{Ll}+)\b
      And inside an EXCEL formule:
      =TOROW(IFERROR(REGEXEXTRACT(A2;"\b(\p{Lu}\p{Ll}+)\s((?:(?:\p{Lu}(?:\.?\s?)*)\s?)*)(\p{Lu}\p{Ll}+)\b";2;0);""))
      (maybe you have to replace all ; with , for your region settings of Windows)
      This regex is looking for 2 words after each other with a capital begin letter and the rest lowercase letters.
      I have used \p{Lu} instead of [A-Z] and \p{Ll} instead of [a-z], so also names from other langues will be accepted, as long as that language supports capital and lowercase letters.

    • @lucascrackers
      @lucascrackers 4 месяца назад

      Will this be available on home and student version?

  • @dustandashes419
    @dustandashes419 4 месяца назад +125

    I have been wanting REGEX in Excel for forever. I'm retired now, but even so, I will still use it. Back when I was extracting addresses from spreadsheets for databases as a function of my job, this would have been an invaluable tool. AI, REGEX, and Excel. What a time to be alive!

    • @ashokwwf
      @ashokwwf 4 месяца назад

      Hello sir, Could you please let me know how have you been using REGEX in Excel so far? Did you build any custom VBA functions? Please share your knowledge, it would be very helpful for me.

    • @katrinabryce
      @katrinabryce 4 месяца назад +8

      ​@@ashokwwf At the moment I use Python to do it.
      Pandas library to open the Excel sheet, the re library to do the regex, and the appropriate database library depending on which database server you are using to write the results to the database.
      If I wanted to write them to the Excel sheet, then I would probably use xlwings to open and read the sheet, the other libraries like re to do whatever calculations I wanted, and xlwings to write the results back to the spreadsheet.

    • @angeiring
      @angeiring 4 месяца назад

      Finally REGEX came to Excel! I'm using an addin on Excel but I can't use the addin's REGEX inside LAMBDA(), having it natively will help A LOT.

    • @anil-bhowte
      @anil-bhowte 4 месяца назад

      I have been waiting for the same for the last 10 years. I have been using this feature in VBA.

    • @Tonymrtn
      @Tonymrtn 4 месяца назад +1

      @@katrinabryce I use a simple VBA code to reverse parse this. Basically you dynamic export the parameters to create a full set library and then parse the result to get to the end product. You can also set the import function to do a modular call but its complicated. Once done, depending on our DBMS, we’ll initiate a connection using SQLAlchemy or a comparable ORM to handle the data persistence layer. If we’re looping back to Excel, xlwings will handle the I/O operations, ensuring data integrity while we execute our computation logic

  • @mrpage221
    @mrpage221 4 месяца назад +44

    You're the best for keeping us apprised of all of these new functions. Thank you for all your hard work for our benefit.

  • @ivanbork4175
    @ivanbork4175 4 месяца назад +16

    As always, you take not only a good an interesting object, but You also present it, so it´s to easy understand and use .
    That being said, I´m starting to be a little critic about MS and their promises of upgrading, it often takes about a year and a half from seeing new object to the actual rollout.

    • @katrinabryce
      @katrinabryce 4 месяца назад +3

      Yes, it is probably a good idea to look back at the videos on this channel from about 2 years ago for tips that you can actually implement today.

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

      Exactly my point

  • @JonLondrezos
    @JonLondrezos 4 месяца назад +5

    I had to write complicated VBA functions to use the regex libraries before. This is a game changer

  • @brijkishorkatesaria8208
    @brijkishorkatesaria8208 4 месяца назад +4

    Thank you Leila for your continuous effort and support

  • @chrisouellet2832
    @chrisouellet2832 4 месяца назад +5

    yeah! - RegEx is finally here!! thanks for your quick tour Leila! this is just awesome!

  • @abhishekkuradia898
    @abhishekkuradia898 4 месяца назад +12

    Finally Regex in Excel, Thank you lord and thank you lelia as always you have the most valuable and up-to-date content.

  • @Bay_Archer
    @Bay_Archer 4 месяца назад +1

    The majority of my excel knowledge I've learned from your videos. Thank you so much. I play with excel for fun and love trying the learning your tips!

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Great to hear! Thanks for tuning in.

  • @nassimabed
    @nassimabed Месяц назад +1

    Before that I used nested FIND and LEFT and RIGHT and MID and these formulae were complex, all leveraging the pattern to build logical extraction tools around it. Now one function does it. Sweet

  • @s2r2420
    @s2r2420 2 месяца назад +1

    Great insight. How much I missed these functions in good old days. Anyway, better late than never. Thanks a ton for this info.

  • @LucasNegreiros-k1y
    @LucasNegreiros-k1y 28 дней назад

    Thanks, you're changing the world with that. Nice work and clear explanations as always. 💚

  • @chongyh2178
    @chongyh2178 4 месяца назад +2

    Thanks Leila! Tutorial on BREAKING up the combined words in Excel using Regextract is actually not BAD..

    • @JJ_TheGreat
      @JJ_TheGreat 4 месяца назад

      Haha!!! I see what you did there!!! 😉

  • @Illiakubasov
    @Illiakubasov 14 дней назад

    Incredible. I can’t think of any document where this would not be useful. Awesome.

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

    Amazing. I wish this had existed 10 years ago as these examples are *exactly the kinds of things I would have to do regularly and figure out how to do with older functions or code. You explanations and lessons are very well put together. But this is the first one that I actually did download your very helpful lesson material. Thank you.

  • @vijayarjunwadkar
    @vijayarjunwadkar 4 месяца назад +1

    Thank you Leila, It's really cool to have the regex functions in Excel now and you have done great job in explaining them in the best way as usual. 🙂 Hoping to see more "REGular" videos from you, so I can "EXpress" better and better! 😁

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Thank you so much, Vijay! There will be more. 😊

  • @jagex4me
    @jagex4me 4 месяца назад +1

    Was using a combination of FIND, MID, LEN and some more. This is definitely easier.
    Next is finding a way to have Excel conclude on the nature of a transaction after doing several of these evaluations. Nesting IF statements has its limitations.
    Thanks for sharing. Now we wait patiently until it is available 😊

  • @Chihiro33333
    @Chihiro33333 13 дней назад

    This is exactly what I need! I do hope I have the feature already! 😀

  • @TheReal_iMan
    @TheReal_iMan Месяц назад +1

    I like want I'm seeing and I like the you sell the idea first before getting into the details.

  • @luckymandragoran8471
    @luckymandragoran8471 4 месяца назад

    This just made my day! I lost weeks of work on new formulas because excel crashed yesterday. It also uses regex in office scripts. The rebuild can have this now and it will be way faster too.

    • @LeilaGharani
      @LeilaGharani  4 месяца назад +1

      Yay! Let‘s hope it gets rolled out soon.

  • @RandalSullivan-n4b
    @RandalSullivan-n4b 17 дней назад

    Thank you for the video and the practice file both are and will extremely helpful!😁👍

  • @ali.jawwad
    @ali.jawwad 2 месяца назад

    This is really helpful. Thanks for the video.

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

    I think the purpose of developing this function was to convert the Flash fill static structure into dynamic.
    It is super handy and useful.
    Thank you

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

    Amazing! I have needed this so much in my apparel analysis where so much info is unstructured text. 🤩

  • @ConradWong
    @ConradWong 4 месяца назад +5

    It was such a headache to do regex extraction via VBA or Power Query routes. What a wonderful addition.

  • @krzysztofmazurkiewicz5270
    @krzysztofmazurkiewicz5270 4 месяца назад +1

    Having to play with Regex in C and C++ was fun but here it looks easy ;)

  • @balendranrajanathan6808
    @balendranrajanathan6808 4 месяца назад +1

    Fabulous New Function explained expertly and easily

  • @PearsAreOkay
    @PearsAreOkay 4 месяца назад +1

    Finally, I get to regex that stage 5 clinger from my life!

  • @mochan8447
    @mochan8447 3 месяца назад +2

    Excellent share thanks!
    In tab 3 you have dragged down the same formula in C2:C11 so it only works at the row level and outputs at the row level. Here is a single cell version of the same formula that processes the entire B2:B11 range at once and outputs a dynamic array from C2:E11 with one single formula:
    =LET(
    dates, BYROW(B2:B11, LAMBDA(row, TEXTJOIN("-", TRUE, IFNA(REGEXEXTRACT(row, "(\d{4})-(\d{1,2})-(\d{1,2})"), {"","",""})))),
    splitDates, TEXTSPLIT(TEXTJOIN("-", TRUE, dates), "-"),
    INDEX(splitDates, SEQUENCE(ROWS(B2:B11), 3))
    )
    Similarly in tab 7 you can use the following single cell formula in C2:
    =BYROW(B2:B11, LAMBDA(row, TEXTJOIN(" ", TRUE, REGEXEXTRACT(row, "([A-Z][a-z]+)", 1))))
    and the following single cell formula in B2 in tab 10:
    =REGEXREPLACE(A2:A6,"(.{4})(?=.{4})","$1-")

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

      Oh that is so cool! Thanks Leila and thanks @mochan8447

  • @DaveHart-G
    @DaveHart-G 4 месяца назад

    Something I do once every couple of years is to create a hypertext linked version of a directory listing of files, starting with the standard output of the command dir / s > dirlist.txt This is then imported into Excel & I then have to systematically review the structure of the paths and separate out information like directory / file, file type, path, filename. Sometimes there is meta-data embedded in the path and file name that are helpful to provide fields that you can filter a long list. Each case has generally had some unique characteristics that mean you can't simply create a standard solution. Regex looks like it might simplify some of the analysis and parsing that I have to do.

  • @Abdulrahman.Alnahari
    @Abdulrahman.Alnahari 4 месяца назад +1

    Great work Leila thank you for sharing your knowledge.

  • @chrisreillyfinancialmodeling
    @chrisreillyfinancialmodeling 4 месяца назад

    I think this is going to be hugely helpful for categorization of bank data in a 13 week cash flow forecast.

  • @rolexcel
    @rolexcel 4 месяца назад

    Thanks for this Leila. As an analyst who at times needs to mine large amounts of data that I extract into excel, this will be very useful and save a lot of time. Last year I spent several days mining names, codes and email addresses from a few million random comment records. I have techniques to do this however this would have been more efficient, both faster and easier.

    • @LeilaGharani
      @LeilaGharani  4 месяца назад +1

      That's a great use case for Regex. 😊

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

    I don't have this function yet, and I really need it today. Great tutorial.

  • @jonasfermefors
    @jonasfermefors 4 месяца назад

    Absolutely brilliant function. Thank you, Leila, for the video. This one will save me lots of time... when I get it.

  • @era.dotcom
    @era.dotcom 2 месяца назад

    ok, i'll be waiting for this Regex function, Leila, thanks🙏

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

    Interesting, very interesting. Even as a home/hobby Excel user i can see me using this. 😀 I know nothing about REGEX, I had hard of but never seen it. Your explanations was enough as get me started in seeing the patterns of how it works. 😀 Once it’s available to the average user this is going to be worth the learning more about.😀

  • @adrianogiacomini6541
    @adrianogiacomini6541 2 месяца назад

    yeeeee!!!!!!
    Finally I can remove the morefunc library from my pc and can install excel 64 bit!!!!
    I have been waiting for this moment for almost 15 years
    🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳

  • @chh8860
    @chh8860 4 месяца назад

    Whoa! ... Leila on Wednesday? ... a surprise ... a very pleasant surprise!
    Regex appears to be a very powerful function ... I will be a student for quite awhile before I can 'solo' with this function. But I was formulating several ideas during Prof Leila's flawless presentation.
    Thank you ... thank you ... thank you ... 😍😍😍

    • @dchall8
      @dchall8 4 месяца назад

      It was excellent but I noticed a flaw. At about 16:40 when replacing special characters, the $ in Ver$ion was deleted and not replaced by an s.

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Yeah, I got too excited and I didn't want to sit on it for another day. 😁
      As always, thanks for tuning in!

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

    regex in Excel is game changer

  • @dianew.1568
    @dianew.1568 4 месяца назад

    Thanks for sharing this Leila! It looks awesome! Can't wait for this new feature. I wish it was already out.

  • @GerhardHolzer911
    @GerhardHolzer911 4 месяца назад

    Tolle Hilfen - ich bin schon sehr gespannt, wann es verfügbar sein wird; und danke wie immer für das tolle Video

  • @toritramel666
    @toritramel666 4 месяца назад +2

    Sweet! Thanks for the tips. I used to use it in sheets and was bummed when I went to a company that blocks sheets.
    Side note: The variation in REGEX pronunciation is kind of like GIF, hotly debated. Although it stands for Regular Expression, many people (myself included) pronounce it with a "J". This is due to the standard rule saying that if a g is followed by an e, i, or y, it's a soft g and says /j/ like "giraffe". But others stand firmly by "It stands for reGular expression so it's G like girl"

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Interesting. Thanks for sharing!

    • @Melds
      @Melds 4 месяца назад

      I've never heard it with a hard G sound before and was wondering if it's a regional pronunciation.

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

      gif=graphics, regex=regular. simple, no j's anywhere.

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

    Amazing stuff. Amazing Teacher!! You ROCK Leila!! 👊🏼👊🏼👍🏼👍🏼

  • @shinybit
    @shinybit 3 месяца назад +1

    Excel ecosystem is finally catching up to command-line scripting (Linux etc...) which allowed us to do this decades ago.

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

    Learned a lot, taking out leading zeroes is however easier with type conversion, =A1+0, probably even if it then needs to be converted back to string (&"").

  • @alinecardoso9668
    @alinecardoso9668 4 месяца назад +5

    I wanna change my profession and unfortunately I think I won't use Excel anymore, I have learned to enjoy it, I'll miss it

  • @joles72
    @joles72 4 месяца назад

    It is great to finally have this in excel! Thanks for the video!

  • @piggybankaccountant
    @piggybankaccountant 4 месяца назад +5

    I LOVE the fact that you are using AI to extract the pattern from regex! Feels like advanced excel has been unlocked to the world!

  • @Rood67
    @Rood67 4 месяца назад +2

    Should have been available for the last few decades. Not like RegEX is new.

  • @akshaysarkar905
    @akshaysarkar905 4 месяца назад

    Thank you for this. I hope this will be available to the public very soon.

  • @TheDigitalOne
    @TheDigitalOne 4 месяца назад

    Ehehehe, excellent time saving useful Excel formula turned into an very useful function. Thanks. for the introduction and teaching the new function. The function does seem to have a few glitches here and there, but with a few tweaks here and there the function does seem to work quite fine! 👌🥰✨💎

  • @cameronhampton1315
    @cameronhampton1315 4 месяца назад

    This is amazing. I have a few ideas where this will save me so much time. Great video as always.

  • @ExcelWithChris
    @ExcelWithChris 4 месяца назад +1

    Love it. I only find it very frustrating that Microsoft takes for ever to roll out the new stuff. Still waiting for tick box option and even PIVOT formulas.

  • @bellepili
    @bellepili Месяц назад

    Thank you for this!! ❤ And say hi to Poldi for me 🤗

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

    I love the way that u explain and everything can you please do a video about visual basics?

  • @jrdexterinc
    @jrdexterinc 4 месяца назад

    Thanks, Leila, this was very helpful. As usual

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

    Hi, thank you for sharing this! I couldn’t find this in ms excel ms 365 though like you’re using in the excel so easily

  • @mythals
    @mythals 4 месяца назад

    I can't wait for this function to be rolled out, it will be a massive time saver.

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Definitely. Hopefully it will not take that long.

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

      Leila how can I make money with excel . I also have knowledge of excel but don't know where to use my expertise

  • @anandgoud4120
    @anandgoud4120 12 дней назад

    thank you so much mam!! you are amazing.....

  • @Autocurator
    @Autocurator Месяц назад

    Just impressive 👍🏻

  • @alvarorodriguezlasso
    @alvarorodriguezlasso 4 месяца назад

    Awesome, regards from Cali-Colombia

  • @TRIVIAFOOT977
    @TRIVIAFOOT977 4 месяца назад

    Thanks a lot. you are always bringing us updates. 👍👍👍

  • @kadairh
    @kadairh 4 месяца назад

    Thank you so much this is awesome! Plus all the other formula keywords I didn’t know existed like TOROW!

  • @markpodesta4605
    @markpodesta4605 4 месяца назад

    Thank you Leila. More magic from Excel! 😀

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

    Hello Sir,
    Thank you for your useful videos on dax.
    Sir, when to combine ALL function with Calculate + Filter Function together in Dax ?
    Could you please make a video of it in detail soon 🙏

  • @MagdyTawfikA
    @MagdyTawfikA 4 месяца назад

    Thank you Leila for this information, much appreciated!

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

    Nice to see MS bringing what used to be a VBA only function for Excel out of the code abyss.

  • @becs-ps1bb
    @becs-ps1bb 4 месяца назад

    that's a revolution! wow thanks as always Leila!

  • @xyclos
    @xyclos 4 месяца назад

    You are fantastic. Thanks so much Leila!!

  • @ricigri1242
    @ricigri1242 4 месяца назад

    My nr1 source to the rescue😎. Huge thank you

  • @zzota
    @zzota 4 месяца назад

    Brilliant explanation. Thanks Leila.

  • @BrandonFoltz
    @BrandonFoltz 4 месяца назад

    Great video. I would put this into the cool and necessary but still half-baked category. Hopefully it will improve. If we need to go out and find REGEX patterns, add additional functions to control spill direction, etc. it's still clunky in 2024 and the age of AI.

    • @LeilaGharani
      @LeilaGharani  4 месяца назад

      Thanks! Given that this is still in Beta I do expect some improvements going forward.

  • @JonMotivationalRend
    @JonMotivationalRend 4 месяца назад

    Simply brilliant. I was going to suggest using AI as Regex patterns can be tricky.

  • @arch.blender1178
    @arch.blender1178 4 месяца назад +3

    Leila the Legend :)

  • @salahaldeen7924
    @salahaldeen7924 4 месяца назад

    good news, now I can move to excel and maybe ditch sheets, maybe, Thanks Leila

    • @LeilaGharani
      @LeilaGharani  4 месяца назад +1

      😊 It was about time this came to Excel.

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

    Hey Liela, can U plx make a beginner course on "Microsoft Access" please ASAP. Also please add some advance functions as well.

  • @MNovakMNovak
    @MNovakMNovak 4 месяца назад

    It's great news, something that should have been there for so long. I used vba in the past to create my regex function, but there are always limitations to vba...

  • @ageloskolaitis7821
    @ageloskolaitis7821 4 месяца назад

    Thanks for the update. Wish there was an easier way to find the expressions than using AI to find the expression. Like pre-saved expressions in separate formula arguments.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 4 месяца назад

    Thanks for the share.

  • @youteubakount4449
    @youteubakount4449 4 месяца назад

    I'll believe it when I see it. Still waiting for Python which was announced like 6 months ago.

  • @MrJamesguy1
    @MrJamesguy1 4 месяца назад +1

    At 15:00 I personally find it a lot easier to simply multiply by 1. This deletes all the leading zero's and makes it a value.
    However, this is only possible if there is no other text.

  • @fano974
    @fano974 4 месяца назад

    Amazing examples, thank you

  • @SavedbyGraceCT
    @SavedbyGraceCT 4 месяца назад

    Thank you, Leila!

  • @abdulsamedhabibulla9174
    @abdulsamedhabibulla9174 4 месяца назад

    Awesome! Thank you Leila!

  • @Lerxsty2112
    @Lerxsty2112 2 месяца назад

    Hey Leila, when the heck is MS going to put some animations in Excel? I can imagine charts and 'floating' tables flying into place with the click of a slicer! Can you imagine the interactive dashboards?! Maybe they'll listen to you if you start bugging them for it. Thanks for everything you do!

  • @sakura0291
    @sakura0291 4 месяца назад

    OMG, I was just thinking of this while at work today... I had to manually type them T_T

  • @mar4kl
    @mar4kl 4 месяца назад

    I see why Microsoft didn't introduce REGEX until after they came out with CoPilot! I have a programming background, and even for me, having to construct one of those "regular expressions" on my own would be sufficiently daunting that I wouldn't consider it worth the effort unless I had a very large amount of data to process or had to parse text like this frequently. Even just trying to modify or debug one looks pretty challenging. At least with AI on hand to provide the regular expressions, REGEX becomes accessible. Still, I suspect anyone who doesn't spend a lot of time writing Excel formulas will just shake his head at this and move on. You did a terrific job explaining and demonstrating it, though.

  • @osjohnmagpale167
    @osjohnmagpale167 2 месяца назад

    Hi, been searching for excel gods in youtube and by far you are the best! Can you help me direct what functions do I use in my scenario. I have multiple entry forms to be filled out by different departments (data collection stage). Once filled up, I copy and paste it on my masterlist. Any suggestions on what function I use so that the multiple entry forms autopopulate my masterlist in a chronological order. Dept.A and Dept. B, etc can do different task on the same day, meaning on my masterlist I manually sort the task by date (using the Sort & filter). And to top it all of, once data is entered in the master list, it has a unique transaction code which sometimes gets broken when some departments submit late and antidated reports.
    Any leads on this on what functions I may use to dynamically auto populate my masterlist based on the data across multiple entry forms in Chronological Order. Thank you soo much.

  • @learningwithmaliha
    @learningwithmaliha 4 месяца назад

    Amazing function!

  • @didierseverac
    @didierseverac 4 месяца назад

    I hope they'll add this to power query to !

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

    This is useful function.Thank you.

  • @uchennaanunike9019
    @uchennaanunike9019 4 месяца назад

    Leila is a Breaking Bad fan, I stan the bests. RegEx is the most difficult function I have encountered after recursive lambda

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

    Hello Mam,
    When to combine ALL function with Calculate + Filter function in DAX ?
    Could you make a video of this please ❤

  • @mr_tw
    @mr_tw 4 месяца назад

    Damn it... I meant to have this playing in the background while I'm updating my bookkeeping, but 30 seconds in and you have my undivided attention...

  • @AHMADFAIZSIHAM
    @AHMADFAIZSIHAM 4 месяца назад

    Pengetahuan baru, makasih banyak!!!

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

    Nice video

  • @jerry5149
    @jerry5149 4 месяца назад

    Yay! As always, a great presentation!

  • @john_tann
    @john_tann 4 месяца назад +1

    That example for the email addresses is scary. Can't imagine coming up with that without co-pilot. I was expecting it to say *@*.

  • @rodrigonoschese9981
    @rodrigonoschese9981 4 месяца назад +1

    Please release this quick!