Script to remove the "returns" inside a text string
I do a lot of copying and pasting from external text sources into Filemaker fields.
This particular text source that I am copying from and pasting into a FM field has a lot of returns ( I guess for sizing reasons ) so that when I paste into the FM text field, it is narrow and very long.
Now I can manually fix this by going to the begining of each line and deleting the return so that the returns are removed and the format is back to normal, but this is tedious and time consuming.
How do a create a script that I can run on a field that will automatically eliminate all internal text "returns"??
Any help here would be greatly appreciated.
I have FMPro Advanced 12 v2
OS - Windows Vista on desktop, Windows 7 on laptop
Try this as an auto-entered calculation on your field:
Substitute ( Self ; ¶ ; " " )
and clear the "do not replace existing values " option.
This will turn all returns into spaces.
Note though that it does it for all returns, if you type in a return to force a line break, this calculation will also remove that return as well.