Thank you for this video, you are a very clear presenter.
@mikebenstead7600
9 ай бұрын
Mind blowing! Programming just got a hell of a lot simpler.
@douglasteixeiragoncalves6084
2 жыл бұрын
Great video Jonah! You helped me a lot.
@svenGPT
3 жыл бұрын
Thank you! Helped me a lot. By the way: nice music at the end.
@DevProTips
3 жыл бұрын
Thanks so much, Sven!
@dodgewagen
4 ай бұрын
Thank you. Very useful!
@MrDoubleYa
4 жыл бұрын
This video is great. Love the real world examples. Keep up the good work.
@DevProTips
4 жыл бұрын
Thanks, Walter! I appreciate the support!
@ALSawad
2 жыл бұрын
Hey Jonah, thanks for the video, I'm wondering how I would extract alpha(s) and the spaces and excluding the digits.
@chiragjain101
3 жыл бұрын
That was butter smooth 👍👍
@suhasdeore3288
3 жыл бұрын
Woooww...great tricks..amazing. 👍👍
@DevProTips
3 жыл бұрын
Thanks!
@Michael.design
3 жыл бұрын
Hey Jonah, great tutorial! I was wondering if you could help me.. I'm trying to extract values after the specific word 'rawValue'. The values that follow that word come in three different variations: A word: rawValue=\"— A large positive number: rawValue=\"280243000\" A large negative \"-280243000\" A small number: rawValue=\"0\" =(REGEXEXTRACT(A60,".*rawValue=(.*)")), which only extracts the first value. How would I be able to extract them all? The amount of cases in a cell varies as well. Thank you in advance!
@DevProTips
3 жыл бұрын
Google Sheets only allows a single capturing group to return 1 match, so you'll need multiple groups. You can use REGEXREPLACE to insert capturing groups and then extract all of the groups that are captured. Here's an idea to get you started: =REGEXEXTRACT(A60, REGEXREPLACE(A60, "(rawValue=)(\S+)", "$1($2)"))
@sunpy7908
4 жыл бұрын
Wow, thank you. fantastic and super quick. Subbed
@DevProTips
4 жыл бұрын
Thanks so much!
@joshuacohen5618
2 жыл бұрын
I used this regular expression in Excel previously ^(GP\:){0,1}9716[123] to find any of these values "97161" "97162" "97163" "GP:97161" "GP:97162" "GP:97163" However, this expression is not working in Sheets. Do you have any suggestions to correct the expression? Or other ways to search for those values in a formula?
@DevProTips
2 жыл бұрын
That formula should work for most cases. If you're doing an extract, the parentheses around the GP: part make it a capturing group which will make it so just the GP: will be extracted. Putting ?: at the beginning of a group makes it non-capturing and more efficient if you don't intend on using the GP: value by itself. In short, this is how I'd simplify it if GP: does not need to be captured: ^(?:GP:)?9716[123]") If you want to detect it *within* a string and not just the beginning, you'll want no anchor: (?:GP:)?9716[123]")
@NewToneProducer
3 жыл бұрын
This is a world of excel/sheets that I didn't know existed
@markjoseph2423
2 жыл бұрын
Hello can you help me fot my project? I want to extract the first 2 words of the file name. And if the first word is numbers. I want to extract the next 2 words to it. Pls help. I can pay thru paypal.
@gulshansharma4469
2 жыл бұрын
Please share this sheet for practice
@DevProTips
2 жыл бұрын
Feel free to make a copy and use it as you wish docs.google.com/spreadsheets/d/1LkhqhGgiXDb4x1ouZeJOUwKlVd3LJpJDDMgBe12RQcU/edit?usp=sharing
@gulshansharma4469
2 жыл бұрын
@@DevProTips thanks
@Robin-sw1is
2 жыл бұрын
I showed this to my boyfriend and he said "I love how Google Sheets turns you on".
Пікірлер: 25