Function String Extras Class

VBNameToDeriveName

"Visual Basic Name To Derive Name" Converts a Visual Basic identifier into one that is valid within the Derive. Derive is a symbolic Math program from Soft Warehouse of Honolulu, Hawaii.

Signature (Visual Basic / VBA)

Public Function VBNameToDeriveName( _
    ByVal vExpr As Variant _
    ) As Variant

Code Example

    VBNameToDeriveName("Side1") = "S_ide1"
    VBNameToDeriveName("Pay Rate") = "P_ayR_ate"
    VBNameToDeriveName("side#2") = "side2" ' #3

Parameters

Parameter Description
vExpr The Visual Basic identifier which is to be converted into a Derive identifier. Function returns Null if vExpr is Null or cannot be fixed up to a String.

Notes & Version History

Note Function ignores most punctuation-type characters which are not valid within Derive identifiers as in example #3.