General

Re: Substring after a last special character

anotherchrisberry — Fri, 25 May 2007 20:33:30 GMT

Is the length of the substring variable? If it's always two or three characters, you could use something like this:

substring-after(substring(ID, (string-length(ID)-3)), "-")

Re: Substring after a last special character

Mancha — Fri, 25 May 2007 08:50:11 GMT

Thanks for your replies.

The length of the string is variable. I have to get the substring after the last character ("-") in a rule.

Via code I know how can I solve this problem but via rule I don't know.

Re: Substring after a last special character

erinselena — Wed, 23 May 2007 19:35:13 GMT

You could use the LastIndexOf method of the string to find the position of the last "-" and then use the substring method to get the string from the last index to the end of the string.. here is an example.

string test = T123-ABC-DEF-GHI-JKL-CC;

int position = test .LastIndexOf( "-" );

string temp = test .Substring( position ); // you may have to say position + 1 here not sure.

int position = test .LastIndexOf( "-" );

string temp = test .Substring( position ); // you may have to say position + 1 here not sure.

Re: Substring after a last special character

Clay Fox — Wed, 23 May 2007 18:59:46 GMT

Are there always the same number of characters or the same number of "-"?

If so you could use the substring length or nested substring-after functions.

There are quite a few examples on the site here.

Substring after a last special character

Mancha — Wed, 23 May 2007 15:19:58 GMT

Hi all,

I have an field ID (sample T123-ABC-DEF-GHI-JKL-CC). How can I get the substring afte the last character "-"? I need the substring "CC".

Thank for your help.