getbetween(text, starttext, stoptext,occurrence)
Rate this function: Average rating: 3.8 (12 votes)
Discuss this Custom Function
Bailey Kessing, NCI-Frederick
http://kessing.com
gets the text between two search values
Sample Input:
getbetween("cefcbabcdefg", "ab", "ef",1)
|
|
Sample Output:
|
Description:
This functions allows you to get any text in a field between two search text strings.
Updated 11/12/201 to fix somebugs.
Updated 6/1/2006 to add the ability to get the "stoptext" after the occurence of the "starttext". Before if the stoptext exist both before and after the starttext it would return nothing. Updated 8/2/2006 to add ability to leave off teh start and/or stop position and defaults to the first char and last char.
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:Make 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) |
 |
|
Doesn't work.
Bill Doerrfeld, Seattle
October 16, 2009 2:40pm