I have a cell that contains a text as part of the cell. When I do a "Text" search (using Microstation's explorer advance search) for the string within the cell, it does not return a result. I believe its because the text is treated as part of the cell and since it's searching for "Text" and not "Cells", it wont work. When searching for "Cells" there is no text element I can select so this doesn't work either. I want to be able to use search to find all instances of this cell, how can I get this to work?
You may be able to do something with Reports.
You can use Find/Replace text to find a string within a cell. However, that only does one at a time, so if you need a total of the elements, Reports may be the option.
You could also write a VBA macro that could search text in cells, but that could get a bit complicated because of the nesting levels within cells as complex elements.
MaryB
Power GeoPak 08.11.09.918Power InRoads 08.11.09.918OpenRoads Designer 2021 R2
Would it be possible for you to provide a screen capture of what has been entered into the Explorer Advanced Search tool for you to try to locate text within a cell?
Advanced Search Dialog
Also, is there any specific reason you wanted to perform the search using this manner?
Have you tried the Find/Replace Text tool. This has an option to search In Cells.
Find Text (or Find/Replace Text) Dialog
RegardsAndrew BellTechnical SupportBentley Systems
John Doe said:When I do a "Text" search (using Microstation's explorer advance search) for the string within the cell, it does not return a result
We wrote a VBA macro to enable text search that includes an option to examine cells...
MaryB said:You could also write a VBA macro that could search text in cells
Well, you could, but that would be reinventing the wheel. Our VBA macro is freeware, not locked, and includes full source code.
MaryB said:Reports may be the option
Good suggestion! I don't know if a Report can peek inside a complex element.
Regards, Jon Summers LA Solutions
if you know the cell name after you found one you can use the select by attributes tool to find them all in a selection... then next step depends what you want to do with or to them
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
The cells are not named. However, turns out advance search does work. There's a display issue that led me to believe otherwise. An element must be selected before highlighting the search results. If not, text elements within cells will not display. This led me to believe they were not returning as results. Not sure if this is a bug or if it's been fixed. FYI, I'm on version 14.