How can I extract the sub-string before the last occurance of a delimeter in a string.
string = "aaDtext1Dtext2"
Delimeter = D
answer I need = aaDtext1
InterSystems IRIS for Health™ is the world’s first and only data platform engineered specifically for the rapid development of healthcare applications to manage the world’s most critical data. It includes powerful out-of-the-box features: transaction processing and analytics, an extensible healthcare data model, FHIR-based solution development, support for healthcare interoperability standards, and more. All enabling developers to realize value and build breakthrough applications, fast. Learn more.