Copy/Increment text

Marina Gillott said:

Does MicroStation has a tool to Copy/Increment

As far as I can tell, MicroStation's Copy and Increment Text tool works only on numbers.

Marina Gillott said:

At the time a VBA was the solution

VBA is an answer when the desired functionality is not provided by MicroStation's built-in tool.  Here's one freeware tool.

Marina Gillott said:

Increment letters (A, B, C...)?

Please provide a before-and-after example:

1. Text to be incremented
2. Resulting text

What do you expect to happen when the text is more complex?

• Before: Tony Gee A
• After: Tony Gee B

• Before: Tony Gee Z
• After: Tony Gee ?

Perhaps you're seeking a revision generator for drawing sheets?

AA
AB
AC
...
AZ
BA
BB
BC
...
BZ
CA
...

Hi Marina,  The only way I really know without using VBA is the solution shown in the screen shot I did here.  For example, if you have a group of letter A's and you want to change all of them to B, you can place a fence around the letter A's, choose the 'Find/Replace Text' option and type A into the find box and B into the replace making sure 'use fence' is ticked.  This will update all at once.

If you're looking for more of an auto-update....A copy B copy C copy etc.  I'm afraid VBA would be the only way I'm aware of.  It only seems to be quick and simple doing this with something of numerical value.  I've no idea why now in Connect we don't have this simple option to do this with letters as well as numbers as it would be very useful.

Marina Gillott said:

Does MicroStation has a tool to Copy/Increment letters?

Try  this macro: Increment Text.

Steven Margach said:

I've no idea why now in Connect we don't have this simple option to do this with letters as well as numbers

Probably because nobody has sought such a tool.  Propose an Idea!