We have mixed format identifiers with both periods and underscores in them (ex. RR10.153 and RR10_354). We are trying to make it so that all identifiers have underscores rather than periods because they don't work with macs as well. Is there a way to convert periods to underscores? (ex. RR10.153 -> RR10_153).
Is this a text field in your database? Don't see why that would create an issue for Mac systems, but Replace Field Contents can be used with the substitute function to replace periods with underscores if this is a text field and not a calculation field.