Glad to hear that you're enjoying the software. There are no limitations in the trial version, other than it stops working after 30 days. That said, here's what I think it happening on both of the issues you've mentioned:

REPLACE

Because its more common to replace in bulk in a database, the Find/Replace doesn't work quite the same way as it would in, say, a Word Processor. The File > Replace mechanism (ctrl + H) only works in the scripting editor. So, if you are writing a script and need to find/replace, this is the way you'd do it.

However, you can indeed replace data in your table as well by using the Update Records panel (Data > Update Records).

For more information on the replace/update functionality take a look at the help page here:

In version 4.2 there is a known glitch where sorting may not work correctly if any of the following things are true:

1. The table name has spaces in it. If this is the case, just double click the name in the project tree and add an underscore (change "my table" to "my_table")

2. Field names have spaces in them. In this case, toggle to the structure view (View > Design View) and double click on the fields with spaces in them to rename ("my field" to "my_field").

If this fix doesn't work, please let us know and we'll debug it further. Our next iteration of the software should be out in the next month (it will be available as a free upgrade to any purchasers of 4.2) which will fix this spacing problem.

Also, if you need any help with the replace/update dialog, just let me know and I'll be happy to help.

About halfway through we show how you can clean up a telephone field by translating things like parentheses, slashes and spaces into hyphens to get a consistent formatting. Also, if you know how to use regular expressions, these are also available via calculated fields.