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

I am able to capture two values in two separate contexts in the BPL. One through an API call and another by looking at the contents of PV1:7. These are context.Prov and context.ProvName. I am checking to see if the values contained in the contexts are the same and if yes process further and if not stop.

In the IF statement I tried the below but none worked. Can someone please tell me what I am doing wrong. The trace does show that they are the same value so that's not it.

1. context.Prov = context.ProvName

2. "context.Prov" = "context.ProvName" and

Hi,

We're using a database gateway from IRIS to Oracle using ODBC. It has been occurring a character set issue that invalidate special characters.

Oracle support has found data type missmatch in ODBC debug while transfering data between the databases.

ODBC was download from official website.

Is there any Intersystems contact to send it to check whether there is a ODBC issue? I hasn't found any directy contact in Intersystems in website.

Is your team onboarding new members, but not sure where to begin their training—and where to go next?

Are you trying to upskill, but need a path to get you to the next level—and beyond?

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
So if you did a major change and expect a changed review just let me know.
Reviews by other members of the community are marked by * in the last column

VSCode is the most used IDE in the world. It is strategic have more extensions for VSCode for InterSystems technologies to keep increasing the developer community.

My new app IRIS VSCode Global Editor is an excellent sample to learn how to create extensions to IRIS. You can check it on https://openexchange.intersystems.com/package/IRIS-Global-VSCode-Editor.

When running a sql insert query with CONVERT('datetime', '2023-12-12 11:27:00',120) in an insert statement into a table this works on one server and not the other.

i.e. to record datetimereceived

Good morning,

Thank you for taking the time to read, understand, and answer this question.

If you needed to convert a message where questions are separated by "|", and the question text is the portion before the ":" and the response is the portion after the ":"; Which way would be the most readable and understandable for other developers?

Input example:

NAME OF SQUAD 1?:ALPHA|NAME OF SQUAD 2?:BRAVO|NAME OF SQUAD 2?:ANSWER THREE||NAME OF SQUAD 25?:YANKEE|NAME OF SQUAD 26?:ZULU

Output structure:

Hello everyone,

I want to share my experience configuring an IIS server to enable secure HTTPs access to HealthShare/HealthConnect.

Hi All,

I'm trying to connect to an IRIS instance using VSCode, the problem is, there are 2 IRIS instances installed on this server, published by the same hostname using https (port 443) under 2 different subfolders (e.g., iris.demo.com/base & iris.demo.com/test).

When connecting via studio, I was able to connect by using the hostname (e.g., iris.demo.com) and specifying the super server port, while when connecting through VSCode, when specifying the web server port 443, the connection is always defaulted to one of the instance.

InterSystems FAQ rubric

If you want to run an OS executable file, command, or a program created within an InterSystems product when the InterSystems product starts, write the processing in the SYSTEM^%ZSTART routine. (The %ZSTART routine is created in the %SYS namespace).

Before you write any code in SYSTEM^%ZSTART, make sure that it works properly under all conditions.

Hi, I need to use some pythonic library from cos.
To use them I need a python dict with some python object in it
Ex in python:

It's true! QuinielaML has incorporated the most important leagues in Europe (and Brazil) into its prediction service, so, dear members of the Developer Community, wherever you are from, you will be able to have the predictions of your favorite leagues at your disposal.

From the predictions screen you will have access to each of the new leagues included, being able to record the matches for each journey: