Return the specified match at index from a regex pattern.The behavior of this function follows the behavior of Python’s match objects: when index is zero and there’s a match, return the entire match, otherwise return the content of the index-th match group.
Parameters
str | StringValue
required
int | IntegerValue
required
re.replace
Replace the matches of a regex pattern with a replacement string.
Parameters
str | StringValue
required
str | StringValue
required
re.search
Returns True if the regex pattern matches a string and False otherwise.
Parameters
str | StringValue
required
re.split
Split the expression using a regex pattern.
Parameters
str | StringValue
required
re.upper
Return a copy of the expression with all characters uppercased.
Was this page helpful?
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"turntable","colors":{"primary":"#ff996d","light":"#ff996d","dark":"#ff996d"},"favicon":"/favicon.png","logo":{"light":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448","dark":"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_dark.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=d5b369063e4b595b13529633741a060f"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://www.turntable.so/get-started"}},"footer":{"socials":{"twitter":"https://twitter.com/Turntable","github":"https://github.com/turntable-so","linkedin":"https://www.linkedin.com/company/92694701/"}},"navigation":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"turntable","hasAudioNarration":false,"actualSubdomain":"turntable","customDomains":["docs.turntable.so"],"gitSource":{"type":"github","owner":"ianrtracey","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{},"buildId":"6ae91ef1dd662a242ab81001:success","clientVersion":"0.0.4138","searchFilterCounts":[{"language":"default","tag":"Reference","count":23},{"language":"default","tag":"CLI","count":11},{"language":"default","tag":"Extension","count":9},{"language":"default","tag":"Column Reference","count":9},{"language":"default","tag":"Basic Concepts","count":5},{"language":"default","tag":"Getting started","count":3},{"language":"default","tag":"Connectors","count":3},{"language":"default","tag":"FAQ","count":2},{"language":"default","tag":"Column-level lineage","count":2},{"language":"default","tag":"Docs composer","count":2}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"reference/column/re","slug":"/reference/column/re","pageMetadata":{"title":"Regex Operations","description":null,"href":"/reference/column/re"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={p:`p`,..._provideComponents(),...props.components},{Accordion,Heading,ParamField}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!ParamField)_missingMdxReference(`ParamField`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`re-extract`,children:`re.extract`}),`\n`,_jsx(_components.p,{children:`Return the specified match at index from a regex pattern.`}),`\n`,_jsx(_components.p,{children:`The behavior of this function follows the behavior of Python’s match objects: when index is zero and there’s a match, return the entire match, otherwise return the content of the index-th match group.`}),`\n`,_jsxs(Accordion,{title:`Parameters`,id:`parameters`,children:[_jsx(ParamField,{body:`pattern`,type:`str | StringValue`,required:true,id:`param-pattern`}),_jsx(ParamField,{body:`index`,type:`int | IntegerValue`,required:true,id:`param-index`})]}),`\n`,_jsx(Heading,{level:`2`,id:`re-replace`,children:`re.replace`}),`\n`,_jsx(_components.p,{children:`Replace the matches of a regex pattern with a replacement string.`}),`\n`,_jsxs(Accordion,{title:`Parameters`,id:`parameters-1`,children:[_jsx(ParamField,{body:`pattern`,type:`str | StringValue`,required:true,id:`param-pattern-1`}),_jsx(ParamField,{body:`replacement`,type:`str | StringValue`,required:true,id:`param-replacement`})]}),`\n`,_jsx(Heading,{level:`2`,id:`re-search`,children:`re.search`}),`\n`,_jsx(_components.p,{children:`Returns True if the regex pattern matches a string and False otherwise.`}),`\n`,_jsx(Accordion,{title:`Parameters`,id:`parameters-2`,children:_jsx(ParamField,{body:`pattern`,type:`str | StringValue`,required:true,id:`param-pattern-2`})}),`\n`,_jsx(Heading,{level:`2`,id:`re-split`,children:`re.split`}),`\n`,_jsx(_components.p,{children:`Split the expression using a regex pattern.`}),`\n`,_jsx(Accordion,{title:`Parameters`,id:`parameters-3`,children:_jsx(ParamField,{body:`pattern`,type:`str | StringValue`,required:true,id:`param-pattern-3`})}),`\n`,_jsx(Heading,{level:`2`,id:`re-upper`,children:`re.upper`}),`\n`,_jsx(_components.p,{children:`Return a copy of the expression with all characters uppercased.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Regex Operations","description":null,"href":"/reference/column/re"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"re.extract","slug":"re-extract","depth":2,"children":[]},{"title":"re.replace","slug":"re-replace","depth":2,"children":[]},{"title":"re.search","slug":"re-search","depth":2,"children":[]},{"title":"re.split","slug":"re-split","depth":2,"children":[]},{"title":"re.upper","slug":"re-upper","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"turntable","siteName":"turntable","title":"Regex Operations - turntable","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-07T00:52:01.774Z","originalFileLocation":"reference/column/re.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"turntable\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Regex Operations - turntable\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"turntable\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.turntable.so/reference/column/re\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://turntable.mintlify.site/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Regex+Operations\u0026amp;theme=4436d9fd61f818e90d58c0cb\u0026amp;signature=73eb2ac125e04496fae04d7a1a5b1cb4e9878b36894f4b1c7a3d8b8aa62e28e5\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Regex Operations - turntable\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://turntable.mintlify.site/_mintlify/api/og/v2?division=Column+Reference\u0026amp;title=Regex+Operations\u0026amp;theme=4436d9fd61f818e90d58c0cb\u0026amp;signature=73eb2ac125e04496fae04d7a1a5b1cb4e9878b36894f4b1c7a3d8b8aa62e28e5\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/turntable/Dj3WJb4nh77Ftel1/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"turntable\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff996d\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.turntable.so/reference/column/re\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/reference/column/re.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.turntable.so/#organization\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/turntable/R01qYC8M1Qe_GhCg/logo_light.png?fit=max\u0026auto=format\u0026n=R01qYC8M1Qe_GhCg\u0026q=85\u0026s=cb06ad2dabda5538ca5e0c7934f06448\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.turntable.so#website\",\"name\":\"turntable\",\"url\":\"https://docs.turntable.so\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.turntable.so/reference/column/re#webpage\",\"url\":\"https://docs.turntable.so/reference/column/re\",\"name\":\"Regex Operations\",\"dateModified\":\"2026-01-07T00:52:01.774Z\",\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"},\"breadcrumb\":{\"@id\":\"https://docs.turntable.so/reference/column/re#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.turntable.so/reference/column/re#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Reference\",\"item\":\"https://docs.turntable.so/reference/table\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Column Reference\",\"item\":\"https://docs.turntable.so/reference/column/standard\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Regex Operations\",\"item\":\"https://docs.turntable.so/reference/column/re\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.turntable.so/reference/column/re#article\",\"headline\":\"Regex Operations\",\"name\":\"Regex Operations\",\"url\":\"https://docs.turntable.so/reference/column/re\",\"mainEntityOfPage\":{\"@id\":\"https://docs.turntable.so/reference/column/re#webpage\"},\"dateModified\":\"2026-01-07T00:52:01.774Z\",\"publisher\":{\"@id\":\"https://docs.turntable.so/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.turntable.so#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"turntable\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"turntable\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/reference/column/re.md","siteName":"turntable","nav":{"global":{"anchors":[{"anchor":"Join our Slack","href":"https://join.slack.com/t/turntable-community/shared_invite/zt-25p0olvhz-Z~c5QWq1jv2YFHQ46mMFDA","icon":"slack"},{"anchor":"GitHub","href":"https://github.com/turntable-so/vinyl","icon":"github"}]},"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/security/on_prem_agent"}]},{"tab":"Extension","pages":[{"title":"Extension","href":"/extension/getting-started/prerequisites"}]},{"tab":"CLI","pages":[{"title":"CLI","href":"/vinyl/introduction"}]},{"tab":"Reference","groups":[{"group":"Connectors","pages":[{"title":"Postgres","href":"/reference/connectors/postgres"},{"title":"BigQuery","href":"/reference/connectors/big_query"},{"title":"File","href":"/reference/connectors/file"}]},{"group":"Reference","pages":[{"group":"Table Reference","pages":[{"title":"Table Operations","href":"/reference/table"}]},{"group":"Column Reference","pages":[{"title":"Standard Operations","href":"/reference/column/standard"},{"title":"Math Operations","description":null,"href":"/reference/column/math"},{"title":"Regex Operations","href":"/reference/column/re"},{"title":"String Operations","description":null,"href":"/reference/column/str"},{"title":"Struct Operations","href":"/reference/column/obj"},{"title":"Datetime Operations","href":"/reference/column/dt"},{"title":"Map Operations","href":"/reference/column/dict"},{"title":"URL Operations","href":"/reference/column/url"},{"title":"Array Operations","href":"/reference/column/array"}]}]}]}]},"basePath":"","title":"Regex Operations - turntable","buildId":"dpl_715YoAgvjTGBDdo8RtXmHKM22b5p","deploymentId":"dpl_715YoAgvjTGBDdo8RtXmHKM22b5p","dynamics":[],"chunks":[]}