So we are exporting data from FileMaker Pro. We have a column labeled as location and it will say something along the lines of: Tank II Rack 3 Slot 23. (There are 3 tanks, 10 racks each, and 81 slots in each rack). We are uploading this data into a different program, so the text value has to be the same. In this new program that same example location would be expressed as: U2R3S23. So I need a way to auto-change the word Tank to U, Rack to R, and Slot to S. Can this be done?
By: Brennan Tschop