subString before last delimeter

Question

Question

Krishnaveni Kapu · Apr 23, 2024

#Caché #Ensemble #Health Connect #InterSystems IRIS #InterSystems IRIS for Health

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

Discussion (4)2

Log in or sign up to continue

Roger Merchberger · Apr 23, 2024

The $LENGTH function can give you the number of PIECEs in a string, and the $PIECE function can grab multiple pieces, so for your example:

S DELIM="D"
S STRING="aaDtext1Dtext2"
W $PIECE(STRING,DELIM,1,($LENGTH(STRING,DELIM)-1))

Edit: Links to documentation for the $PIECE and $LENGTH functions:

$PIECE: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fpiece

$LENGTH: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_flength

Hope this helps!

0 0

Enrico Parisi · Apr 23, 2024

Within $piece, instead of $LENGTH(STRING,DELIM) you can use *

0 0

score 0 · Answer 1 · 2024-04-23T08:05:56-04:00

USER>set string = "aaDtext1Dtext2"

USER>write $p(string,"D",1,*-1)
aaDtext1

Edited to add relevant documentation link.

score 0 · Answer 2 · 2024-04-23T08:25:11-04:00

With more recent versions, yes. The user didn't state what version Ensemble was in use, so I figured offering a solution that would work as far back as Ensemble 2009 wouldn't necessarily be a bad thing. I still have to support Ensemble 2012 and I did test the *-1 functionality there, and in that version this functionality did not yet exist. (Actually, a few sites I support are still using Cache 5.x. It may be geriatric, but it keeps on plugging along... :-) )