Further to my last post, the Translate function does work, it's just my limited knowledge of Xpath Syntax. Anyway, for those of you who do want to know:
translate(@Name[@JobCodeID = @JobCode], "&/\*?<>:", "")
That's all my illegal characters at the end.
translate(Field, "Characters", "Character(s) to replace or leave blank to remove)
Make sure all parts are seperated by a comma