What is the best why to change the format of data in a cell?

I have a data set that brings in names under the column BDM Name with FY 2024 at the end of the name, see below screenshot. What is the best way to remove the "FY2024?" I have about 8 BDM names I need to change. Should I use a replace text tile in ETL?
Best Answer
-
You can use a replace text tile in an ETL to remove the known value, "FY2024". Or a command like this if it's static:
TRIM(SUBSTRING(`BDM Name`, 1, LENGTH(`BDM Name`) - LENGTH('FY2024')))
Or get a be more complicated using a regular expression in a formula:REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', '')
and wrap the TRIM command in there for spaces
TRIM(REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', ''))
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
You can use a replace text tile in an ETL to remove the known value, "FY2024". Or a command like this if it's static:
TRIM(SUBSTRING(`BDM Name`, 1, LENGTH(`BDM Name`) - LENGTH('FY2024')))
Or get a be more complicated using a regular expression in a formula:REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', '')
and wrap the TRIM command in there for spaces
TRIM(REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', ''))
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thank you! The command worked great.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 874 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive