Identifying specific text in Stratigraphy table, with its depth?

I've been asked to identify the soil descriptions that contain "TLM", and capture that with it's depth, for showing on a fence diagram.  (TLM isn't identified in its own field, but in the Description field).  Is there any expression or rule I could apply to pull that info from the description?

Thanks,

Terry

Parents
  • Hi Terry,

    Pulling something from a text string is difficult. The best option would be to use the LIKE function 

    You could have a description entity with an output condition which is found under the entity properties in the configuration tab.

    <<Like(<<LITHOLOGY.Description>>,"*LTM*")>>

    There are certainly things that could slip through if the data entry isn't consistent, but this is probably the easiest implementation. 

    Answer Verified By: Terry Boutelle 

Reply
  • Hi Terry,

    Pulling something from a text string is difficult. The best option would be to use the LIKE function 

    You could have a description entity with an output condition which is found under the entity properties in the configuration tab.

    <<Like(<<LITHOLOGY.Description>>,"*LTM*")>>

    There are certainly things that could slip through if the data entry isn't consistent, but this is probably the easiest implementation. 

    Answer Verified By: Terry Boutelle 

Children
No Data