B64TOGUID Function
This function converts a base64-encoded GUID to a standard 8-4-4-4-12 format.
Syntax
B64TOGUID(base64-GUID)
Where base64-GUID is a 22-character string representing the base64-encoded form of the GUID.
Returns the 36-character (including hyphens) string representing the standard 8-4-4-4-12 format of the GUID if successful, otherwise returns a blank string.
Example 1
B64TOGUID("D+Gzt6Ahk6MOWxK2Va6nW6")
Returns the GUID 3f86cede-8086-4e8c-ba75-ea5a652bb1e5.
Example 2
B64TOGUID(CLP146)
Returns the CWFileID GUID from the Windows File Properties dialog of the engagement file.