I've got dozens of raw files I load each day (see attachment). I've got a script (attached) that processes these in to QVD format. I've got a field in the raw data called Capacity that shows the figure as a percentage (i.e. 25%). I want to trim the '%' sign from this field whenever it occurs. I don't simply want to trim the last character in case it's not a %, so the script must specifically trim '%' signs only from this field. What's the best way to achieve this?