SOLVED
Remove dashes
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
nihou
8 - Asteroid
‎01-19-2021
11:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What is the best way to remove dashes and decimals from a string? 12-345-6789-12-34 & 12.345.6789.12.34. results wanted: 1234567891234
Replace([Field1], "-", "")
Replace([Field1], ".", "")
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
3 REPLIES 3
15 - Aurora
‎01-19-2021
11:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-19-2021
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @messi007
15 - Aurora
‎01-19-2021
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
