Substr statement

[ybz12003]

Hi, all:

I found these codes written from previous programmer.   Is it the (1,length(indicator)-1) in IND and (length(indicator),1) in TYPE are the same?  Please help.  Thanks.

Y

IND=substr(INDICATOR,1,length(indicator)-1);

TYPE=substr(INDICATOR,length(indicator),1);  

[PGStats · Accepted solution]

IND is the whole string except the last character

TYPE is the last character

[ybz12003]

I don't quite understand why TYPE is the last character.

[ybz12003]

SUBSTR( ) Used on Right Side on Assignment Statement.

SYNTAX: 

=SUBSTR (char_string, start_position,no_of_chars_to_read );

extracts char string from start position and with length given. 

In that mean, TYPE is starting the whole length of "INDICATOR", and only extract the last number? right?

[PGStats]

For example, "ybz12003" has length 8, so the string of length 1 starting at position 8 is "3".

[ybz12003]

Thanks