After ( text ; searchString ; occurrence ; include_1 )
Rate this function: Average rating: 4.8 (5 votes)
Discuss this Custom Function
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
extracts text after search string
Sample Input:
After ("jim@aol.com" ; "@" ; 1 ; 0)
After ("aa:bb:cc" ; ":" ; -1 ; 1 )
After ("¶a¶b" ; ¶ ; 1 ; 0) |
|
Sample Output:
|
Description:
After ( text ; searchString ; occurrence ; include_1 )
by Fabrice Nordmann
v.2.1 Sept 2007
v.2, Mar 2007
v.1, Jan 2007
v2 adds inclusion boolean parameter.
v2.1 corrects a bug with searchstring
extracts the end 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)
e.g. After ( "1234512345" ; "2" ; -1 ; 0 ) = "345"
see also Before, 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:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
GetResultParameter( ParameterName ) |
| |
(Wed, Aug 25, 8:32am) |
| 2. |
GetListParameter ( ParameterList ; ParameterName ) |
| |
(Wed, Aug 25, 8:25am) |
| 3. |
Standard_Deviation( Field ; MaxLoopCount ; StartIndex ; StdDeviation ; ArithMeanValue ) |
| |
(Tue, Aug 24, 10:57am) |
| 4. |
Arithmetic_Mean ( Field ; MaxLoopCount ; StartIndex ; MeanValue ) |
| |
(Tue, Aug 24, 10:51am) |
| 5. |
Age ( Birth; theDate; Format ) |
| |
(Fri, Aug 20, 9:50am) |
| 6. |
Power ( x ; y ) |
| |
(Thu, Aug 19, 5:56am) |
| 7. |
portal.rowCount ( _name ) |
| |
(Sun, Aug 15, 2:41pm) |
| 8. |
PostPer_Day ( Post; startDate ; finishDate ; returnType ) |
| |
(Sat, Aug 14, 2:02pm) |
 |
|
Examples need to add the include_1 parameter, which I learned to use a zero for after looking at the After custom function
David Owen, Bloomfield, CT, USA
July 02, 2009 12:47pm