topic Re: How to Batch Edit Table Text in AutoCAD Forum

How to Batch Edit Table Text

alissonsgarcia — Wed, 08 May 2024 22:14:04 GMT

Hi.

I have a table that was configured in an old job with black font colour.

Since I use a black backgroup colour as well, nothing is visible.

The only solution I found so far was to enter editing mode in every single cell, select the text and change the colour from black to "by layer", but that's an impractical solution and consumes too much time.

It must exist some way to fix this for the entire table in one go.

Can anyone help me here?

Re: How to Batch Edit Table Text

pendean — Wed, 08 May 2024 22:24:36 GMT

@alissonsgarcia wrote:
...The only solution I found so far was to enter editing mode in every single cell, select the text and change the colour from black to "by layer", but that's an impractical solution and consumes too much time.
It must exist some way to fix this for the entire table in one go....

Are you not able to click-drag across all cells-release in your tables? That's been a feature for as long as AutoCAD has had tables

Re: How to Batch Edit Table Text

alissonsgarcia — Wed, 08 May 2024 23:27:30 GMT

@pendeansomething very strange happens here.

If I try to select anything by clicking outsite of the table, like shown below, nothing is selected:

If I try to click anywhere inside the table, it selects the cell. Then, I can click again and use a rectangle selection to select multiple cells, open properties, and make the change you suggested, but nothing changed again! If I select a cell, after making that change, and check its properties, I can see that the cell is set to have clour defined by layer, but that setting doesn't affect the text inside the cell at all! It's like the text inside the cells are using settings that overwrites whatever settings I pick for the cell itself. It seems like the cell setting is different from the settings of the content inside the cell. Not sure if you could understand that explanation here. It's just too bizzar.

The text inside all cells, except on the first row, are invisible on model space, but when hover the mouse over it, the text is then displayed:

I selected the first cell, and check the properties for text colour, it's set to: ByLayer. Even though the layer has a white colour, the text isn't displayed. If I change the layer, it also doesn't affect the text colour. It remains invisible.

In order to facilitate your help, I'll share the DWG file with only that table in it. See if you can figure out what is happening, please.

You can download it from the link: https://file.io/xS3zflf2iFUQ

Thanks

Re: How to Batch Edit Table Text

vinodkl — Thu, 09 May 2024 11:41:51 GMT

Hello @alissonsgarcia

Please use the lisp attached to format the color of the text in the table. Download the .lsp file and drag and drop into AutoCAD. Now type in the command "STRIPMTEXT" to invoke the function and select the table. Next in the popup window select only "COLOR" and click "OK" to format the color of the text in the table 🙂

Betreff: How to Batch Edit Table Text

cadffm — Thu, 09 May 2024 11:51:39 GMT

StripMtextv5-0d

Re: How to Batch Edit Table Text

pendean — Thu, 09 May 2024 12:15:35 GMT

@alissonsgarcia wrote:
...If I try to select anything by clicking outsite of the table, like shown below, nothing is selected...

Not sure that's what I showed in my screenshot: are you familiar with how a crossing window selection looks and works in AutoCAD? Perhaps you are new to AutoCAD: a crossing window selection is what I used.

From right-to-left, you click-and-hold then drag-and-release when you have what you want include windowed (the rectangle is dashed like in my screenshot, not solid lines like in your screenshot). Try it now. In a TABLE, your first and last crossing window clicks MUST always be while hovering over a cell.

Re: How to Batch Edit Table Text

alissonsgarcia — Thu, 09 May 2024 21:59:56 GMT

@pendean

As I previous wrote:

"If I try to click anywhere inside the table, it selects the cell. Then, I can click again and use a rectangle selection to select multiple cells"

So, I did selected all the cell, as explained previously, I opened the Properties tab, changed the text colour, but, as I also mentioned, that didn't change anything.

Quoting myself again:

"after making that change, and check its properties, I can see that the cell is set to have clour defined by layer, but that setting doesn't affect the text inside the cell at all! It's like the text inside the cells are using settings that overwrites whatever settings I pick for the cell itself. It seems like the cell setting is different from the settings of the content inside the cell."

So, your solution was tried.

It didn't work though.

Re: How to Batch Edit Table Text

alissonsgarcia — Thu, 09 May 2024 21:55:02 GMT

@vinodkl @cadffm

both of you shared that solution.

My first question is: is that a custom solution you created, a custom script?

My second question would be:

Is there any way to fix that colour without installing aditional things, in order to be a long lasting solution for the future and avoid me the need to come here again to download that file and set up that new function when I work on a different computer or update the system?

The proposed solution did make the text visible.

I would insist in knowing a little bit more about what was proposed and if I can sort it out with the native existing commands.

Regards,

Re: How to Batch Edit Table Text

pendean — Fri, 10 May 2024 12:02:32 GMT

@alissonsgarcia Share your problematic TABLE in a DWG file for all of us to try: either there is something quite unique about it that you may be missing or a fix might be trying something else.

TIA

Re: How to Batch Edit Table Text

alissonsgarcia — Sat, 11 May 2024 07:29:07 GMT

@pendean please read the previous messages. The DWG file was shared in my first reply to you.

Re: How to Batch Edit Table Text

pendean — Tue, 14 May 2024 13:36:46 GMT

@alissonsgarcia wrote:
@pendean please read the previous messages. The DWG file was shared in my first reply to you.

Nope, never was anything there, nothing there now and nothing in your shared link either when I tried it before posting and why I asked for it again.

Re: How to Batch Edit Table Text

alissonsgarcia — Tue, 14 May 2024 21:16:42 GMT

Hi @pendean

@pendean wrote:
Nope, never was anything there, nothing there now and nothing in your shared link either when I tried it before posting and why I asked for it again.

You're mistaken @pendean

Please, see screenshot below.

It was shared before, as I mentioned. you just missed it.

Now the link doesn't work anymore, saying the file is deleted. It seems that server don't keep the file available for a long time. That's all. But the link was there, is there, but it doesn't work anymore.

It was working perfectly fine when it was posted, before it expired and was deleted.

I'm updating the link to that file below.

This new link in using my dropbox subscription, so it will remain there for at least an year from now.

https://www.dropbox.com/scl/fi/fdisztoowomqhvpd0k7l9/Table-Problem.dwg?rlkey=7r1kx04fq9m8wyyelsybbhgmt&st=f7mwi14k&dl=0

Let me know if you have any issues with that one.

Regards,

Betreff: How to Batch Edit Table Text

alissonsgarcia — Tue, 14 May 2024 21:24:14 GMT

@cadffm wrote:
StripMtextv5-0d

@cadffmwhat is the difference between your file ending with D and the one offered as solution before your post, ending with B?
Same question applies to @vinodkl

StripMtextv5-0d

Re: How to Batch Edit Table Text

pendean — Tue, 14 May 2024 21:34:58 GMT

See attached (I removed all the AutoCADMECH tools in it, is that the software you are using or got this file from?): each of your "black" cells has a manual in-editor override for style and color, while everything else in that table followed your TABLESTYLE settings.

Now we know why the core AutoCAD tools could not edit your table text.

Betreff: How to Batch Edit Table Text

cadffm — Tue, 14 May 2024 21:37:53 GMT

Hi,

Version 5.0c contains an extension to version b and Version d contains another extension to version c.
In both cases it involves information about the text height, which could not yet be recognized and handled in the respective previous versions.

So, it has nothing to to with an internal color-format, but with possibles internal Text height formats

Betreff: How to Batch Edit Table Text

pendean — Tue, 14 May 2024 21:40:55 GMT

@alissonsgarcia wrote:
@cadffm wrote:
StripMtextv5-0d

@cadffmwhat is the difference between your file ending with D and the one offered as solution before your post, ending with B?
Same question applies to @vinodkl
StripMtextv5-0d

Betreff: How to Batch Edit Table Text

alissonsgarcia — Tue, 14 May 2024 22:17:19 GMT

@cadffm Where did you get that from? It doesn't seem like you created that file, correct? Maybe I can find a good source of functions and other stuff to add to my AutoCAD.

Is there any way to fix that table without using this external function and also without manually editing each individual cell? The problem is solved for me anyway, but out of curiosity, in case I receive similar table in the future from someone, that information might come in hand.

Regards,

Betreff: How to Batch Edit Table Text

cadffm — Tue, 14 May 2024 23:07:19 GMT

@alissonsgarcia schrieb:

@cadffm Where did you get that from? It doesn't seem like you created that file, correct?

Right, I downloaded the 5.0c version (what is published on several sites)

and after I got the "okay" from one of the programmers, I added/edited some lines.

Maybe I can find a good source of functions and other stuff to add to my AutoCAD.

You will find 100.000 programs in many API/languages easily.

Each is useful if you have the task that the tool is doing.

One of the most shared site in this forum: Search about Lee Mac or cadalyst and so on.

Is there any way to fix that table ...without manually editing each individual cell?

No

, in case I receive similar table in the future from someone, that information might come in hand.

For usual I use my own tools, but to remove internal Mtext format codes in my daily tasks, I use StripMText!

(my personal version is more powerful, but the published version works perfect by gui)