Reduce Identical Entries in a Log Report Column

John Sharkey asked: I’m trying to update our CPT log to output an interpreted soil behavior type. Our CPT software collects a data record every tenth-foot or so for the entire length of a sounding. When this data is processed, we get a corresponding soil behavior type for every tenth-foot interval, but many adjacent entries are identical. I’d like to display the soil type on our log, but every 1/10 foot is a tad excessive.

I’ve added a User System Data table to define the input/output soil type correlation, but would like the text to output once only, at the midpoint of each unique soil type interval.

ANSWER: There is actually a gINT Help topic that covers this, though it isn’t intuitive to find. Look for “Consolidating Depth Text (how-to guide)” in the Help Index.

The description in Help assumes that you will have the data output at the top of the zone of matching behavior, but the expressions can also be adjusted to position it at the mid-point between top and bottom of the zone.