Selecting a String from the right of a character

[jdgreen]

I have a string, KC1055-SP11#B5-BLK/SMK, that I need to map only the data to the right of the # sign. Unfortunately, the length of the data varies as does the start position within the string. I know there is a way to set it up to look for the character and map the information there, but I'm at a loss.
Thanks in advance.

John Green

 

[Babelabout]

Which mapping tool are you using?

With XSLT, I would simply use the "substring-before" or "substring-after" functions ;-)

/Patrice -

http://www.babelabout.com/about.html

 

[jdgreen]

Using Gentran 5.1

John Green