RightPosition ( text ; searchstring )
Rate this function: Average rating: 3.3 (12 votes) Discuss this Custom Function
Bob Shockey, The Alchemy Group
http://www.alchemy-group.com
Shows everything to the right of the search string in text.
Sample Input:
| RightPosition ( "thequickbrownfox" ; "quick" ) |
|
Sample Output:
|
Description:
Extracts the rightmost part of TEXT based on the position of the specified SEARCHSTRING. Does not rely on word spaces being present to extract the data, so it can be used in any sort of string or fixed-width data.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|