Removing prefix and suffix
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
bbaisil
7 - Meteor
‎01-13-2022
06:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I need to remove the prefix(') and suffix(') from the program display here. I just need the number.
For example '4747' to 4747.
How can I do that ?
Labels:
- Labels:
- Data Investigation
3 REPLIES 3
gabrielvilella
14 - Magnetar
‎01-13-2022
06:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @bbaisil, you can use a Data Cleansing tool and remove punctuation or use a Formula to replace that character with nothing.
Qiu
21 - Polaris
‎01-13-2022
08:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bbaisil
Depends on the context of your " program display", better to use Regex.
atcodedog05
22 - Nova
‎01-13-2022
09:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @bbaisil
Another method is by using Trim function which removes characters from the beginning and ending.
Trim([program_display],"'")
Workflow:
Hope this helps : )