SOLVED
To extract last five letters from a string
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
dizy_11
7 - Meteor
‎06-08-2021
07:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi can anyone please tell how to extract last 5 letters from a string (not in the reverse order).
Thanks in advance.
Solved! Go to Solution.
Labels:
- Labels:
- Regex
2 REPLIES 2
apathetichell
19 - Altair
‎06-08-2021
07:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
non-regex way is to use a formula tool - new column
right([yourfieldname],5)
‎06-08-2021
07:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks alot.
