How can I replace different texts in a dwg file with the help of pairs of search/replace data from 2 columns in an xls table?
+50- Celebrity
You can use a DatabaseJoiner, FeatureMerger or FeatureJoiner to join the Excel data to your DWG and then replace the acad_text_string attribute with the value from Excel.
+2- Contributor
redgeographics wrote:
You can use a DatabaseJoiner, FeatureMerger or FeatureJoiner to join the Excel data to your DWG and then replace the acad_text_string attribute with the value from Excel.
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
+50- Celebrity
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
Correct, your DWG texts will have a (potentially hidden) acad_text_string attribute containing the text, you can join on that.
+2- Contributor
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
thats true but that is not the same as the 1st column. 1st column of the table might contain the entire text or parts of the text i need to replace
+50- Celebrity
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
Aha, that changes things. Can you post a sample?
+2- Contributor
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
here, i've attached a simple example.
+2- Contributor
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
another try for the xls
+50- Celebrity
proteve wrote:
if i understand correctly all these suggestions assumes i have an attribute to join them. i have only a table with 1st column for text to search and 2nd column with the replace value.
I think you would first need to decide what you want to do with partial or fuzzy matches. If it's a simple 1-to-1 match you can use the method I described earlier but for anything else you'll need to work out those rules first.
+2- Contributor
thats the problem. i have parts of text to search and replace. thats why i can't match by attribute. so it's not 1 to 1. i have from 100 to 500 texts in dwg (not unique) and i need to replace them with the matching values from xls file.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.