/* * 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

removing last 5 characters of a value

NathanDorsch

November 2022 in Magic ETL

How can I remove the last 5 characters of a text value in ETL?

0

Best Answer

GrantSmith Coach

November 2022 Answer ✓
Get the left characters up to the length of the last 5 characters.
LEFT(`Field`, LENGTH(`Field`)-5)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2

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 */