Trim 2 characters from right side of string using Workbench
I have a dataset that appends every day and I want to remove 2 characters (.0) from the right side using Workbench.
I thought this would be simple, but Search & Replace does not allow replacing with null, and replacing with a space or other character is also undesirable.
Is there a way to use any of the Workbench Transforms to accomplish this? Calculated field also seems like it wouldn't work because it wants to create a new column, unless I'm misunderstanding it.
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board