Function Math Symbolic Class

BreakParentheses

"Separate First-level Parenthesized Sub-expressions" Adds a string separator (like vbCrLf) after closing first-level parentheses within algebraic (infix) expressions.

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.