This script will allow you to add a prefix or a suffix to all your field names. This is great when performing a join or Visual Connector and don't want the entire file name to be included.
http://ideascripting.com/ideascript/add-prefix-suffix-field-names