EvalCalcInserts ( Text )
Rate this function: Average rating: 4.8 (5 votes)
Discuss this Custom Function
Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
Replace "Calc" to value of Calc Evaluated.
Sample Input:
mailbody = "Hello, <calc>nameFirst</calc> <calc>nameLast</calc>."
EvalCalcInserts ( mailbody ) |
|
Sample Output:
|
Description:
EvalCalcInserts ( Text )
2011.07.25, Koji Takeuchi <takeuchi@nemoux.com>
description:
Replace "<calc>Calc</calc>" to value of Calc Evaluated.
ex.
nameFirst = "Koji"
nameLast = "Takeuchi"
EvalCalcInserts ( "Hello, <calc>nameFirst</calc> <calc>nameLast</calc>." )
= "Hello, Koji Takeuchi."
mailbody = "Hello, <calc>nameFirst</calc> <calc>nameLast</calc>."
EvalCalcInserts ( mailbody )
= "Hello, Koji Takeuchi."
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. |
ValidateTC( MernisNo ) |
| |
(Tue, Jun 18, 6:44am) |
| 2. |
MinValue( theList ; treatAsNumeric ) |
| |
(Wed, Jun 12, 7:59am) |
| 3. |
MaxValue( theList ; treatAsNumeric ) |
| |
(Wed, Jun 12, 7:57am) |
| 4. |
LengthConvert ( Number , From , To ) |
| |
(Fri, May 31, 2:37pm) |
| 5. |
Backwards( _Field ) |
| |
(Thu, May 23, 10:49am) |
| 6. |
FilteredPortalList ( fieldObjectName ; startingPortalRow ) |
| |
(Tue, May 21, 5:33pm) |
| 7. |
ListToggle ( InList ; InValue ) |
| |
(Thu, May 16, 6:59pm) |
| 8. |
VatFormat ( vat ) |
| |
(Tue, May 14, 2:45am) |
 |
|
non recursive version.
Case (
PatternCount ( Text ; "<calc>" ) = PatternCount ( Text ; "</calc>" ) ;
Evaluate (
Substitute ( Quote ( Text ) ; [ "<calc>" ; "\" & Evaluate (\"" ] ; [ "</calc>" ; "\") & \"" ] )
)
; Text
)
Not same result in some case.
1. if <calc></calc> is contained in evaluated result.
2. if there is error, return '?'
3. Using variable
<calc>Let($a=0;"")</calc>
first:<calc&g t;Let($a=$a+1;$a)</calc>
second:<calc>Let($a=$a+1;$a)</calc >
unin, japan
July 28, 2011 8:39pm