Issue with the Convert string value in Nav 2009 r2

If the format pattern that I see in your example strings hold true for all strings, you can use STRPOS to locate the '# ’ substring, and COPYSTR to capture the remainder of the string.