XpressDox News

Version 6.3.0 (2014-10-02)

2014-10-02 Version 6.3.0 The functions SubstringAfterLast and SubstringBeforeLast will get the part of a string before a particular substring, or after it.  For example, you could extract the extension of a file name with «SubstringAfterLast(Filename, ‘.’)» The GetRegistryValue function will enable extraction of values from the Windows registry. A fair number of bugs have been […]

go to article

The SubstringBeforeLast and SubstringAfterLast Functions

These two functions help with manipulation of strings like file paths or IP addresses which have multiple occurrences of a delimiter. For the following examples, assume the data element DocFilePath contains ‘C:\Documents\XpressDox\WordFile.docx’. SubstringBeforeLast can be used to get the name of folder from a full file path, e.g.: «SubstringBeforeLast(DocFilePath,'\')» will get the value ‘C:\Documents\XpressDox’, and […]

go to article

The GetRegistryValue Function

This function does as its name implies: gets a value from the Windows registry. For example: «SetV('UserPrivileges',GetRegistryValue('HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Accounting\Options\UserPrivileges')» This will get the registry value HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Accounting\Options\UserPrivileges and put it into the XpressDox variable called ‘UserPrivileges’.  After that the variable can be inspected and assembly of the document continue dependent on that […]

go to article