Show content different from actual source

[squidley]

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?

[Lee Smith]

You can replace the commas, and the spaces, with a return by using the Substitute Function.

i.e.

Substitute (TextString; [","; ¶] ; [" " ; ""] )

HTH

Lee