DataLoad Window
Menu Functions
Using Spreadsheets
DataLoad Options
Importing Data
Data Validation
Sorting Data
Protecting Loads

User Guide Home
DataLoad Home

Finding & Replacing Data

The Find and Replace functionality is used to find data within the spreadsheet and, optionally, replace that data with a new value. Find/Replace may be used with all keyboard characters as well as some special characters.

Open the Find window using the Find entry on the Edit menu or by pressing Ctrl + F. The text to find should be inserted in the "Find what" box. To find only whole words that match the search text the "Match whole word only" check box must be ticked. If this option is not used then DataLoad will match the search criteria within words as well as returning whole words. By default the search is not case sensitive, for example searching for "DataLoad" will match with "DATALOAD" and "Dataload". To ensure the search is strictly case sensitive the "Match case" checkbox must be ticked. Finally, the direction of search can be specified by selecting "Up" or "Down" and DataLoad will search from the current active cell up or down as selected. When the search criteria have been entered click "Find Next" or press Alt + F to search for the next cell that contains data matching the search criteria. Press "Cancel" to close the Find window.

The Replace window may be opened by selecting Replace from the Edit menu or by pressing Ctrl + H. The Replace window is very similar to the Find window (see above) but adds the ability to replace text. DataLoad will replace the found text with the text in the "Replace with" box. To replace matching text one at a time click the "Find Next" button to find the next matching text and, if a match has been found, click "Replace" to replace that text with the text in the "Replace with" box. To replace all matches at once click the "Replace All" button. Press "Cancel" to close the Replace window.

It is sometimes useful to be able to find and/or replace special characters that do not create a normal visible character. This can be achieved by using a special code in the Find and Replace text boxes, as shown below. These codes are case sensitive and should be lower case otherwise they will be ignored.

Matches with
^p Carriage return (ASCII/ANSI/Unicode character 13)
^l Line feed (ASCII/ANSI/Unicode character 10)
^t Tab (ASCII/ANSI/Unicode character 9)

Note that data originating from a Unix source normally uses just a line feed to separate lines whereas Windows data normally uses a carriage return and line feed. Thus to find and/or replace Windows new lines the ^p^l codes should be used together.