Signature (Visual Basic / VBA)
Public Function BreakParentheses( _
ByVal vExpr As Variant _
, Optional ByVal vSeparator As Variant _
) As Variant
Code Example
? BreakParentheses("((A-B)*C)^(D-E)*(F+G)")
((A-B)*C)
^(D-E)
*(F+G)
? BreakParentheses("((2*X)+A)*(R+4)")
((2*X)+A)
*(R+4)
Parameters
| Parameter | Description |
|---|---|
| vExpr | The algebraic expression which will have its parenthesized sub-expressions separated within the result string. Function returns Null if vExpr is Null or cannot be fixed up to a String. |
| vSeparator | The string that will separate the sub-expressions within the result string. vSeparator defaults to vbCrLf (carriage return, new line characters) if it is missing or Null or cannot be fixed up to a String. |
Notes & Version History
| Note | This function uses the IsAlNum function to determine is characters are alphanumeric. |