SilverAge Software

Search and Replace. Edit. Transform.

Use Cases

Doing search and replace via FTP

This is not actually a techsupport case. This page is an excerpt from the Text Workbench help system which is provided as a good example of using Text Workbench to search and replace text in files on a remote FTP server.


The best way to process remote files on an FTP server is to create FTP accounts using the FTP Locations dialog and then specify a required FTP path by selecting one from the menu.

You will need to have the following data at hand to create an FTP location record:

So, let's get started.

  1. Click on the drop-down arrow of the Folder Functions button and select Manage FTP Locations in the menu:

    This will bring up the FTP Locations dialog box:

    It's still lonely and deserted - let's breathe new life into it!

  2. Click Add Location button. Now there is a new location with the default name. Change the name to something meaningful that will help you recognize this FTP location anytime later... even when you grow old. Perhaps that's too much, but you've got the idea.

  3. Now specify the FTP server data.

    First, enter the server address in the FTP location URL field. It may or may not include the ftp:// prefix - it does not matter. The server address may include the full path to a remote folder. In other words, your location address may look something like this:

    mywork.com
    ftp://mywork.com
    ftp://mywork.com/public/john
    mywork.com/public/john
  4. Then, type in your username and password.

    If your password is good and strong, it is obviously long. To avoid error, you may want to use the Reveal password option: it will show the password characters - in this dialog box only!

    If you're accessing a public server requiring no authentication, tick the Anonymous option.

  5. Your first FTP location is now ready to use. The parameters sheet may look something like this:

    Now, to use it, you have two options. The first is fairly obvious: click Save and Use Selected. We'll exercise another way though, because you'll make much more use of it in future.

  6. Click Save Changes. Now click on the drop-down arrow of the Folder Functions button again and open the Available FTP Locations submenu. Select your new location in it:

    ...and take a look at the Folders text box: it now contains the FTP location path:

Essentially, that's all you have to do to manage and use the FTP locations. Now you can just click Search or Replace.