SOLVED
Removing only two numbers AFTER a decimal
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mfranchino21
7 - Meteor
‎11-15-2023
01:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, i have a string that will look something like this;
45729816345272.36 73648728627811.854376628188193.4792986181921763484553.34 375376327236328textexttext 4572899473689494.233254756466
Every time there is a decimal, I want to remove the following TWO numbers. so, if it sees a decimal, it will take away the following 2 numbers.
I would want the above input to look like this;
45729816345272. 73648728627811.4376628188193.92986181921763484553. 375376327236328textexttext 4572899473689494.3254756466
Solved! Go to Solution.
Labels:
- Labels:
- Behavior Analysis
- Best Practices
- Common Use Cases
- Connectors
- Custom Tools
- Datasets
- Developer Tools
- Documentation
- Dynamic Processing
- Events
- Gallery
- Help
- Input
- Interface Tools
- Join
- Location Optimizer
- Machine Learning
- Macros
- Optimization
- Output
- Predictive Analysis
- Preparation
- Prescriptive Analytics
- Publish
- Reporting
- Run Command
- Scheduler
- Settings
- Tips and Tricks
- Transformation
- Workflow
4 REPLIES 4
binuacs
21 - Polaris
‎11-15-2023
01:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mfranchino21 try the below regex
CoG
14 - Magnetar
‎11-15-2023
01:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Very odd use case, but here you go!
Edit: Didn't think about RegEx, but that's way cooler! Nicely done, @binuacs
‎11-15-2023
01:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
awesome, thank you!
TimN
13 - Pulsar
‎11-15-2023
01:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
