You're confusing substring() and substr(): substring() expects two indices and not offset and length. In your case, the indices are 5 and 2, ie characters 2..4 will be returned as the higher index is excluded.
How to check whether a string contains a substring in JavaScript ...
2 If you know the character also in the string from where you want to get the substring then you can use strstr function. It locates the substring. But if u do not know the character from where you want to retrieve then you can use the strcpy or strncpy to get the string as Eric has mentioned.
O substring irá retornar à partir da posição informada no primeiro parâmetro até a posição informada no segundo, porém, o caractere da posição no segundo parâmetro não é incluído (ou seja, vai até o caractere anterior).
How do I get a substring of a string in Python? - Stack Overflow
The main difference is that substr() allows you to specify the maximum length to return substring() allows you to specify the indices and the second argument is NOT inclusive There are some additional subtleties between substr() and substring() such as the handling of equal arguments and negative arguments. Also note substring() and slice() are similar but not always the same.
Syntax: string.slice(start, stop); Syntax: string.substring(start, stop); What they have in common: If start equals stop: returns an empty string If stop is omitted: extracts characters to the end of the string If either argument is greater than the string's length, the string's length will be used instead. Distinctions of substring(): If start > stop, then substring will swap those 2 ...
The SUBSTRING function doesn't seem to be up to the task because it is position-based and the position of the underscore varies. I thought about the TRIM function (the RTRIM function specifically):