Excel Find and Replace (num) VI
- Updated2024-07-30
- 3 minute(s) read
Searches the occurrences of searched string and replaces them with a new string or numeric value. The data type you wire to the replacement input determines the polymorphic instance to use.

Inputs/Outputs
—
report in is a reference to the report whose appearance, data, and printing you want to control. Use the New Report VI to generate this LabVIEW class object.
searched string
—
searched string describes the string to search for and replace.
replacement
—
replacement is the number that replaces instances of searched string.
format string (%.3f)
—
format string specifies the number formatting to use when LabVIEW converts the numbers to characters. Use format string when you wire numeric data to the replacement input.
error in (no error)
—
error in describes error conditions that occur before this VI or function runs.
—
report out is a reference to the report whose appearance, data, and printing you want to control.
found?
—
found? returns TRUE if the VI finds at least one occurrence of the searched string.
error out
—
error out contains error information. If error in indicates that an error occurred before this VI or function ran, error out contains the same error information. Otherwise, it describes the error status that this VI or function produces. |
—
searched string
—
replacement
—
error in (no error)
—
—
found?
—
error out
—