Function
Description
Example
CleanNumericValue
Removes all characters which are not numeric, decimal points (‘.’) or negation symbols (‘-’).
CleanNumericValue(Field)
CombineRemarks
Combines all values from a particular column where the value in a different column is blank. The values for PROJ_ID and HOLE_ID must be specified either directly or indirectly via a field.
CombineRemarks(‘P001’, ‘BH001’, ‘Blank’, ‘Source’)
CombineRemarksForDepth
Combines all remarks in the current input table for a project and location combination where the depth value is equal to the current row’s depth.
CombineRemarksForDepth(‘P001’, ‘BH001’, ‘DepthColumn’)
GetGeodasyTopDepth
Gets the correct top depth value within the GEOL table. This function assumes that GEOL_TOP is present.
GetGeodasyTopDepth(PROJ_ID, HOLE_ID)
GetGeodasyTopDepthCustomColumns
Provides the correct top depth value (as GetGeodasyTopDepth) but allows the column names to be specified.
GetGeodasyTopDepthCustomColumns(PROJ_ID, HOLE_ID, ‘Project Column’, ‘Location Column’, ‘Stored Depth Column’, ‘Actual Depth Column’)
‘Actual Depth Column’ will be created if it does not exist and will be used to store the effective top depth value.
PrepareParticleTable
Creates a new temporary table which contains individual entries for sieve and percentage passing values. This exists to provide support for lists delimited with a single character, such as ‘^’.
The temporary table will contain a row for each pair and a field per value. The names of the fields will be the same as those specified as the first two arguments.
PrepareParticleTable('SIEVE', 'PPS', '^', 'TemporaryTable')