/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */

Help Center

Community

Regex in Formulas in Views and in Formula ETL Tiles

Byboth

Byboth

September 2022 in Ideas Exchange

I would like to be able to use regex to match values in formulas. Both in views and ETLS Such as this. I am using this to validate some data in a view formula

CASE

when `Field` like '[0-9]{4}\-[0-9]{4}\-[0-9]{3}' then 0

when `Field` = '' then 0

else 1

end

Tagged:

Formulas

4

4

4 votes

Active · Last Updated September 2022

Categories

/* * These styles apply ONLY to the header and footer assets. */ header { height: 60px; } @media screen and (max-width: 1100px) { header { display: none; } } .header__fixed-container { /*position: fixed;*/ width: 100%; z-index: 999; background: #ffffff; height: 60px; box-shadow: 0 2px 5px 0 rgba(0, 0, 0, 0.2); min-width: 984px; /* TODO: revise when a responsive strategy for header is chosen */ } .header__content-container { display: flex; flex-direction: row; justify-content: space-between; margin: 0 auto; padding-right: 40px; } @media (max-width: 762px) { .header__content-container { padding-right: 20px; } } .header__left { display: flex; flex-direction: row; } .header__title-container { display: flex; flex-direction: column; justify-content: center; } .header__title { font-weight: 600; /* open sans semibold */ font-size: 14px; line-height: 24px; text-transform: uppercase; } .header__title-container { margin-left: 16px; } .header__subtitle { font-weight: 300; /* open sans light */ font-size: 20px; line-height: 24px; } .header__logo-container { background: #9ce; padding-top: 20px; padding-bottom: 20px; } .header__logo-image { width: 60px; } .header__right { display: flex; flex-direction: column; justify-content: center; } .header__nav__link-list { display: flex; flex-direction: row; list-style: none; font-size: 16px; line-height: 1.5; margin-right: -20px; } .header__nav__link-list-item { padding-left: 20px; padding-right: 20px; } .header__nav-link { text-decoration: none; color: inherit; } .header__nav-link:hover, .header__nav-link.current { /*color: #99ccee;*/ /* Darker to provide better contrast */ color: #5398c6; } * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #222222; min-height: 198px; padding: 50px 0; display: flex; flex-direction: column; justify-content: center; } .footer { color: #888888; font-size: 16px; line-height: 1.5; } .footer-wrap { width: 100%; max-width: 1224px; padding-left: 20px; padding-right: 20px; margin: 0 auto; } .footer-row { display: flex; flex-wrap: nowrap; justify-content: space-between; align-items: center; } .footer-col { display: inline-flex; } .footer__logo-container { height: 60px; /* margin-right: 40px; */ } .footer__logo-container img { height: 60px; } .footer__link-list { display: flex; flex-direction: row; list-style: none; text-align: center; font-weight: 400; } .footer__link-list-item { padding-left: 20px; padding-right: 20px; } .footer__link { text-decoration: none; color: inherit; } .footer__link:hover { color: #88bbdd; text-decoration: underline; } .footer__copyright-and-privacy-container { text-align: right; } @media screen and (max-width: 1100px) { .footer-row { flex-wrap: wrap; } .footer__link-list { flex-direction: column; line-height: 40px; } .footer-col { width: 100%; justify-content: center; } .footer-col:not(:last-of-type) { margin-bottom: 20px; } .footer__copyright-and-privacy-container { text-align: center; } } /*# sourceMappingURL=styles.css.map */