Before ( text ; searchString ; occurrence ; include_1 )
Rate this function: Average rating: 4.0 (4 votes)
Discuss this Custom Function
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
extracts text before search string
Sample Input:
Before ("jim@aol.com" ; "@" ; 1 )
Before ("aa:bb:cc" ; ":" ; -1 )
Before ("a¶b¶" ; ¶ ; -1) |
|
Sample Output:
|
Description:
Before ( text ; searchString ; occurrence ; include_1 )
by Fabrice Nordmann
v.2, Mar 2007
v.1, Jan 2007
v2 adds inclusion boolean parameter.
extracts the beginning of a text, based on a search string and an occurrence number
occurrence can be positive (starting from the beginning of the text) or negative (starting from the end)
see also After, Between, and BetweenNext functions
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. |
GeoBox(latitude;longitude; radius) |
| |
(Mon, Mar 15, 11:04am) |
| 2. |
MonthNameList ( start; number; short ) |
| |
(Sun, Mar 14, 11:45pm) |
| 3. |
matchListAB( ListA ; ListB; match_Value; match_operator ; getN ) |
| |
(Sun, Mar 14, 10:29pm) |
| 4. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 5. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 6. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 7. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
| 8. |
XORbin( bin0 ; bin1 ; "" ) |
| |
(Sat, Mar 13, 4:35pm) |
 |
|
