How To Use a Case Sensitive Search to Create Geology Code 2 data automatically


When reviewing your Geology data, it may be useful to create custom geology code 2 values based on the descriptions found within the data. This is most common where the main constituents are capitalised within the description. It is not currently possible to do a filter within OpenGround Cloud Professional that is case sensitive (it will treat gravel and GRAVEL as the same) which would allow for a quick interrogation of this data, however, it is possible to export the data and then edit using Excel, then import it back in.



The tool mentioned in the above process can be downloaded from here.


This process and tool was provided with many thanks by one of our users - Jim Poole from Coffey. If you would like any assistance with this process then please contact Bentley Support.