Extract text to the right of the last iteration of a specific character
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need some help getting the text located to the right of a specific character.
For example, here are 2 records that I have:
C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P)
C(I) , E(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , C(P) | C(I) , R(P) | C(I)
I need a way of extracting the text located to the right of the last " | ".
In the 1st record, the result should be "C(I) , C(P)"
In the 2nd record, the result should be "C(I)"
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cfranco
Yes, you can use REGEX to do this.
EDIT: Use Trim function to get rid of unnecessary spaces at the beginning and at the end of the string.
Trim(REGEX_Replace([Field], ".*\|(.*)", "$1"))
This should work.
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Follows a formula below
Right([TEXT],FindString(ReverseString([TEXT]), '|'))
[]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm not that familiar with the REGEX tool. Want to make sure I am using it correct.
I tried your recommendation but didn't get the expected results. Here is the screenshot. Can you clarify?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. This worked. I was not familiar with the "ReverseString" function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. I have a lot to learn and appreciate the support.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @cfranco if you have any questions please let us know.
The Community is here to help.
Cheers,
