January 1, 200917 yr I think I wrote that poorly in the Subject. My goal is to display a field's content formatted differently from how it was actually entered. Specifically, I want to remove all commas and replace them with carriage returns. But this would NOT be a permanent record change by using Find/Replace. It would ideally just be as the field is displayed in a given layout. Right now I've got fields with long strings of words separated by commas. It's hard to read. Carriage returns would make it easier in this case. Is this doable?
January 1, 200917 yr You can replace the commas, and the spaces, with a return by using the Substitute Function. i.e. Substitute (TextString; [","; ¶] ; [" " ; ""] ) HTH Lee
Create an account or sign in to comment