Global edit to numeric text

I don't know of anything, but that sounds like an easy enough task for VBA. If you feel adventurous, I'm sure the folks at the Programming forum would be able to give you some tips on how to write it.

Thanks for your help MaryB,  I was thinking that was the answer but wanted to make sure before spending the time/money to go down that road.

We used to do this all the time. Can't find the UCM we used, it was easy, but UCM is deprecated, though I still use one (lazy), works fine.

With the software in front of me today, I would export the text with the xy value, have my way with it in Excel and simply import it back in.

For that specific task, USGS has this-  NGS Coordinate Conversion and Transformation Tool (NCAT) but it's likely way involved (never used it).

Bob Rayner said:

I would export the text with the xy value ...

That works if the numeric text can be uniquely identified and not mixed with other text on the same level.  If numeric text is mixed with other annotation the export process must sort the sheep from the goats.

Bob Rayner said:

... have my way with it in Excel

The Lorys school of CAD!  But it might just work.

Bob Rayner said:

We used to do this all the time. Can't find the UCM we used, it was easy, but UCM is deprecated

Ah!  User Command Macros:  the path to write-only code.  VBA, and its macro recorder, make life much easier and code more legible than a UCM. Furthermore, you can write VBA that communicates with Excel.

MaryB said:

sounds like an easy enough task for VBA

Yes: VBA is great for scanning a DGN model to find elements, and has the computational capability to differentiate between sheep and goats then perform a numeric computation on the goats.

Bob Rayner said:

I would export the text with the xy value ...

That works if the numeric text can be uniquely identified and not mixed with other text on the same level.  If numeric text is mixed with other annotation the export process must sort the sheep from the goats.

Bob Rayner said:

... have my way with it in Excel

The Lorys school of CAD!  But it might just work.

Bob Rayner said:

We used to do this all the time. Can't find the UCM we used, it was easy, but UCM is deprecated

Ah!  User Command Macros:  the path to write-only code.  VBA, and its macro recorder, make life much easier and code more legible than a UCM. Furthermore, you can write VBA that communicates with Excel.

MaryB said:

sounds like an easy enough task for VBA

Yes: VBA is great for scanning a DGN model to find elements, and has the computational capability to differentiate between sheep and goats then perform a numeric computation on the goats.

Jon Summers said:

The Lorys school of CAD!  But it might just work.

That is a bit cheeky to call it my school of cad, you make it sound like a back handed compliment or a slight  I didnt even join in the post.. I believe in use what is (a] easier, (b] at hand and (c) what you know best

I use a lot of VBA and scripts but most of the VBA are 3rd party paid for so I can't share them as solutions for others other than to suggest as a last option to go buy it or pay for a programmer which I often do post as a option in these forums.

Now a user is faced with a problem he has xyzt as an inbuilt function in microstation and I dare you to find a engineering office  that doesn't have excel as an integral part of their tool set and well versed in its skill levels, yes even in vba in excel is common, maybe not every user but at least one Devotee... so for another to post to use the most logical approach use xyzt and excel is the obvious solution that should have come to everyone ... .. after all I don't post try Flexitable the La Solution school of cad...I said my  piece  let's leave it there and not start a childish flame war....

Lorys said:

That is a bit cheeky to call it my school of cad

No offence intended! 

Jon Summers said:

No offence intended! 

ok, none taken now, but it was a bit cheeky of you.. . insert smiley here X