Auto-change text to different text

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

Leave a Reply

Your email address will not be published. Required fields are marked *