I have text of two two lines in a column of table and i want to make them to single entity in every column

Hi,

King Khan said:

i want  to make them to single entity

it's not precise enough, because single entity in the discussed context can be understood e.g. as cell or text node, which both are single entity, are able to hold texts inside, but are completely different.

King Khan said:

to make them single entity with a click is that possible ?

Yes and now. Did you try to search this web for the same discussions?

You can group elements into cell using Ctrl+G.

It possible to follow this wiki article (easy to find) how to use (quite old) tool txt2node to convert texts to text node.

The conversion is not automatic, because it's pretty complicated process (maintain position, define an origin etc.), but it's simpler than to rewrite the text.

With regards,

  Jan

no i don't want to use group if i use Ctrl+G the text is just grouped and the text is not in a single entity but just grouped and i don't want that . please check the dgn file i have uploaded. i want to make it completely editable text with single entity. thanks for answer.

King Khan said:

no i don't want to use group if i use Ctrl+G the text is just grouped and the text is not in a single entity but just grouped and i don't want that

It seems you do not read my answer, because to group to one entity is exactly what you asked for, see your original question. My note was that until correct MicroStation terminology is used, it can be understood incorrectly (like to use Ctrl+G to create one entity).

King Khan said:

and i don't want that

It's your responsibility to explain clearly what you want and do it in such way, that it will require close to zero effort from readers (which invest their free time to help others).

King Khan said:

i want to make it completely editable text with single entity

It seems you even do not bother to read the wiki article I linked, because it describes how to convert texts to text node.

What more do you expect?

Regards,

  Jan

sorry MR JAN Thanks i didn't read that completely sorry just tried that it is working but it also taking same time as i do manually. is there not any way like just CTRL+G for converting text to nodes please ?

King Khan said:

is there not any way like just CTRL+G for converting text to nodes please ?

I do not know about any other option.

As I wrote, to convert more texts to text node is complex process when implement to work generally and can hardly be fully automated (some manual work will be always required).

An alternative solution is to create e.g. VBA macro to solve specifically your situation. To implement general tool and to create macro for custom situation are two completely different situations and often the macro can be create in a fraction time. So it's about to evaluate whether it's better to do it manually (because it will be done once, so to convert even thousands of text is simpler and faster than to write and test code) or to invest into macro (because the same data will be modified regularly.

Regards,

  Jan

ok I managed to do it pretty close but its fiddley ( faster than individual editing)

What your trying to do is create the acad equivalent of MTEXT which in microstation is text node with word wrap imposed to force a line change at the end of the first line.... ( maybe its easier in acad but you asked for microstation)

you need to select all the text and from file menu select copy

open text editor and paste

all your text is now there and just put an enter at the end of each second line

all your text is now one big node make sure you match the text to your old text first

works better than with excel and equations

if you want to edit  just click on individual piece of text and editor opens at that line for edit

and they all move together as its one big text node.. works great!

No i don't want to make complete text to node. there's 2-2 lines of text in every column and i want to make them 1-1 line text please check  the above  dgn file i have kept for sample thanks for answer lory

No i don't want to make complete text to node. there's 2-2 lines of text in every column and i want to make them 1-1 line text please check  the above  dgn file i have kept for sample thanks for answer lory

Whatever you do, you will have to select both lines of text and copy them into either a new piece of text, or copy one into the other. Whether you include a line break/hard return is up to you.

There is no tool that will automatically take two lines of text and combine them into one sentence. Bentley hasn't developed one because not very many people need to do that often enough. While it may be an obvious thing to you, I can't think of the last time I needed to do that.

If you wanted to get into VBA programming, you may be able to write your own tool. But most of us here have jobs and tasks of our own, and can't afford the time to write anything for you. The folks over at the Programming forum are very helpful, but they do have their own work to do, so they can't do it for you, either. The difficulty of the macro would depend on exactly how you wanted it to work.

Perhaps you have a friend who knows a bit of programming? it may be worth buying them dinner and a couple of drinks to have them come up with something for you. Microstation VBA isn't very much different from any other VB.

That's why we have VBA and MDL programming languages - because Bentley can't think of every possible tool for every single user. They created a robust platform, and gave us the means by which to write our own tools. Asking the same question a bunch of times when every answer is "No, it doesn't exist" wastes precious time you could spend just doing the task or learning how to make your own tools.

I know what you wanted but it cant be done without vba or too much extra work manually as you said it take too line 2 lines at a time

But it works the same as if they were all separate text nodes, and grouped together, there is no real difference  because if say you want to edit line 15 you just click on line 15 and its now visible at line 15 ready for editing ...

This method I outlined  method took me 3 mins from start to finish  result and looks exactly like your rhs example ( revised text rather than excel as you have to be very exact with the equations it gets a little tricky and took me 30 -40 to get it exactly right and you found it hard to get it right on your own... so I revised my post for benefit of others with similar problem).

Before we were allowed to use imbedded excel tables this is the method we use to use .. it was so long ago maybe 20 years that I forgot how we did it... personally I would use an imbedded excel table with lines/ grids and it looks much better but if you have client standards that wont allow it  then the giant text node method is the least expensive time wise and looks indistinguishable from you separate individual text nodes... try my method first then see if it works for you with editing etc.. it was also easier this way with the line spacing and matching your existing original text...

King Khan said:

there's 2-2 lines of text in every column and i want to make them 1-1 line

Text Stitcher Tool

Here's a tool, written in VBA, that stitches two text elements.  You don't need to understand VBA to use the tool.  Just copy it and follow the instructions.

The tool is freeware and unsupported.  Use at your own risk.

very good Jon excellent vba does exactly whats needed rather than copy paste edit, but poster wont like it he wants it to find all the text incidents for him and not have to click each pair by hand... I believe I gave him a very workable <3 min solution  with what is at hand in microstation but he didnt like that either...

Lorys said:

I believe I gave him a very workable <3 min solution  with what is at hand in microstation but he didnt like that either

The OP has a mercurial character.  He expresses his goals inadequately and dismisses answers and suggestions capriciously.  He has posted many questions on this and the Programming Forum in recent weeks, where several of us have contributed time and effort to understand what he wants.  After attempting to answer his questions we're left unknowing whether we helped or not!