Excel allows search and replace, and has the option to "Match entire cell contents", so that you don't replace parts of strings you want left alone. I want that in LV.
The Report Generation Toolkit "Excel Find and Replace" vi contains invoke nodes with variants that may allow that. But I don't know how to find out which variant and value can do the "Match entire cell contents" option.
Is there a reference for that? Or, has this problem been solved already? Google is no help.
Background: I have an Excel template with dummy strings, and I find and replace those dummy strings with values. Parts of the dummy text are repeated, but the entire dummy text is unique. In other words, during the search, "dummy_10" gets the same value as "dummy_1", and now that the string "dummy_10" has been replaced with bogus data, the value for dummy_10 gets thrown out. But if I can match entire cell contents the problem goes away.
