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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive