topic Re: Strings Right and Index in App Development

Strings Right and Index

lucasx15 — Wed, 28 Sep 2022 11:55:32 GMT

Hello everybody.

I have a doubt, I'm different needing to separate these values that are concatenated 2735489-80, in two fields.
I'm using the following in my script:

RIGHT(CD_CALENDAR,INDEX(CD_CALENDAR,'-',2)-1) AS test

However, the value is coming to null. What am I doing wrong?

Re: Strings Right and Index

Or — Wed, 28 Sep 2022 12:01:01 GMT

Index(Field,'-',2) looks for the second instance of '-' in the string. Since there is only one '-' in the string, this presumably returns null.

Re: Strings Right and Index

marcus_sommer — Wed, 28 Sep 2022 12:04:56 GMT

You may simplify this task by using subfield(CD_CALENDAR,'-',2).

- Marcus