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?
Page 1 / 1
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.
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.
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.
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
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?
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.
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
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.
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.