Help specifies what transformations can take place and you're correct there's none that would work for you so scripting would be the way to go. You could write a workflow action script if you already have a workflow working on the record. Alternatively a User Event or map/reduce, it depends on your specific use case.