Strings Right and Index

[lucasx15]

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?

[Or]

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

[marcus_sommer · Accepted solution]

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

- Marcus