LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel search and replace - "Match entire cell contents"

Solved!
Go to solution

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.  

0 Kudos
Message 1 of 3
(639 Views)
Solution
Accepted by AndyTailored

Try this wire a Text Ring control to the LookAt input of the ActiveX Range. The ring has Whole (1) and Part (2).

 

ooth_0-1721223786228.png

 

 

Message 2 of 3
(613 Views)

Don't use dummy text in the cell.  Setup named ranges. 

aputman_1-1721224923129.png

 

aputman_2-1721224966018.png

 

 

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
Message 3 of 3
(599 Views)