I am wanting my StringReplacer to search for values which start with a certain string, and replace the ENTIRE value with a new string (not just the start).
I have table with a list of values starting with "Sh 1" and "Sh 77", and they all have following text after Sh 1 and Sh 77. I would like to replace the entire value, e.g. "Sh 1 Rs 401 Rakaia to Chertsey" should be replaced with "State Highway 1".
I have tried a few expressions, but currently I am only able to replace the "Sh 1" part of the string, not the following text.
How do I change my expression so the entire value is replaced?
