원하는 문자,숫자를 쉽게 추출하기(구글시트 Regexextract함수)[함수소개-기초]
Synopsis
구글 스프레드시트 REGEXEXTRACT함수 예시를 소개하는 영상입니다. 정규식을 잘 몰라도, 단순한 패턴 몇 개 만으로도 유용하게 ...
You Might Also Like
![[구글 시트] 텍스트에서 한글만 추출하기: RegexExtract](https://i.ytimg.com/vi/1cBPgDxw7Hs/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDpwXeRB4UqPqF8YMEu5lK0RpCX9w)
![[구글스프레드시트] regexExtract, regexReplace를 이용하여 숫자만 가져오기](https://i.ytimg.com/vi/2ZbTTIuh2Jg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAPG95dZ3qZJ1VW__QbUVqAlW9tbg)
![원하는 글자만 뽑아온다? mid함수 텍스트 추출 함수 끝판왕 [엑셀함수배우기, 구글시트함수배우기]](https://i.ytimg.com/vi/S79fofoB6Vw/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCMwzFskuIEFNQ89WbfnGZY3sat_g)
![[구글스프레드시트] REGEXEXTRACT 함수의 기본 이해와 패턴에 매칭되는 모든 값 가져오는 UDF](https://i.ytimg.com/vi/nOTzFs5Cv10/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_AmAAtAFigIMCAAQARhyIGIoGDAP&rs=AOn4CLBg7Qu4mLJJbyBxFpt7GLT5togikg)
![텍스트 분리하기(구글시트 SPLIT함수)[함수사용법]](https://i.ytimg.com/vi/H78yEe65JF8/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDbolw9Uq8njx6ZbwBHC3v0H2Yc0A)
![[구글스프레드시트] regexExtract함수에서 정규표현식 Flag설정](https://i.ytimg.com/vi/p2RliFqSiio/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCGcb701fAxKC64h18435Bx3y4JDA)
![[구글스프레드시트] regexExtract를 이용하여 숫자*숫자*숫자 형태 뽑아내기](https://i.ytimg.com/vi/7m5wmyu-v7s/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCOF1Fu68fshEo9_AX6Pw-upAK9Eg)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.