SOLVED
Removing special characters using formula tool
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
dunkindonut7777
8 - Asteroid
‎08-31-2023
05:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have a data here that has special characters, I want to remove it in a formula tool.
Name | Expected output |
Non-payment | Non payment |
Paid/Special | Paid Special |
Just want to know how to formulate it in a formula tool. Thank you
Solved! Go to Solution.
Labels:
- Labels:
- Adobe
2 REPLIES 2
17 - Castor
‎08-31-2023
05:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's an example using regex replace. the [^A-Za-z] means any character that is not (^) A-Z.
REGEX_Replace([Name], '[^A-Za-z]', ' ')
MilindG
12 - Quasar
‎08-31-2023
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dunkindonut7777 Heres couple ways you can do this.
