%20 is a valid URI part in most of the URI so it sounds like you have broken data. There is no generic substitution or treatment that can fix it unless the breakage is regular and predictable which is impossible to guess from your pseudo-sample. With more information about what your data really looks like, you'll likely get better suggestions.