P109 Search and Replace Cell Contents (command line example list)

Example:

Command Line Example 1: Search for "Marine Science" and replace with "Oceanography"

 

 

P109 Command Line Reference:

/P#

Meaning

Extra Parameters

109

Search for and replace the contents of a cell within a spreadsheet

/1 = sSheets - worksheet(s) to be modified (by name or number)

/2 = sSearchFor - text to be modified

/3 = sReplaceWith - replacement text

/4 = sRange - Specify a range, or omit to use 'used range'

/5 = bCaseSensitive - "TRUE" or "FALSE"

/6 = bLookAtPart - "TRUE" or "FALSE"

/7 = bMatchByte - "TRUE" or "FALSE"

This special process allows you to search for text within cells and replace it with other text.

Special Parameters Described in Detail

/1{sSheets} Required. Name of the sheet(s) to modify.

    Sheets can specified by name or number.  

              You may specify ranges by index:  i.e. "2-4,10" or "*" for all.

              You may specify by name: i.e. "Sheet4","Sheet6","Accounting"

/2{sSearchFor} A string that will be searched for and replaced. Required.

/3{sReplaceWith} A string that is the replacement text. Required.

/4{sRange} A string to optionally specify the range to do the search and replace on. For example /3"D:D" will do column D only.

/5{bCaseSensitive} "TRUE" to check case sensitivity or "FALSE" to ignore it.

/6{bLookAtPart} "TRUE" to replace the search string wherever it is found or "FALSE" to replace it only when it comprises the entire cell contents.

/7{bMatchByte} "TRUE" to match double byte to single byte characters or "FALSE" to ignore it.