Batch find and replace from an excel file

[ehughes]

I have a need for an Acad 2014 LISP that will read Excel and whats in column A will be replaced with whats in column B of the same row, about 3200 rows of it. Anyone ever found anything like that? I found something but it doesnt read from or copy from excel. Help please?!?

Evan

[3wood]

Do you refer to block attributes?

[ehughes]

No just text, they are part numbers from old the manufacturer in column A that need to be current manufaturer part/model number in column B.

[3wood]

What is the entity type in AutoCAD? Table? Mtexts with lines? Texts? Blocks?

Can you upload a sample drawing with a sample Excel file?

[Lee_Mac · Accepted solution]

You could use my BFind program for this task.

As it stands, the current version of the program doesn't allow you to import find & replace pairs from an external file, however, you can perform the following steps to import the data into the program:

Start the program, enter a few find & replace entries, and save the list using an arbitrary reference. Then exit the program and type at the AutoCAD command-line:

(findfile "LMAC_BFind_SavedSearches_V2-0.txt")

This will give the location of the file that the program uses to store the find & replace pairs.

I would suggest that you first save a few different search references with the program (using the 'Save' button) and you will then easily see the required format of this text file. The file may then be edited manually to add search/replace items from your spreadsheet, providing that you keep to the same format so that it may be read by the program in the expected format. As a tip, I would suggest first saving your Excel spreadsheet as a tab-delimited text file.

I hope this helps,

Lee

[ehughes]

AWESOME!! That worked great! Thank you very much!

[Lee_Mac]

evan wrote:

AWESOME!! That worked great! Thank you very much!

Glad to hear it evan - you're welcome!

[joãomoura5585]

You are simply the best !

thank Lee Mac

[vinay.moogi777]

hi lee mac

i want change in each and every sheet this bfind can u provide me any solution

[iamwonder]

 I have download "bfind",but it dosent work with chinese ,how can i do?

[teneilew]

I realize this is a very old post but, Lee Mac, you have saved me hours or work once again! Thank you!
T

[yarik89V9ZK2]

 AutoReplaceCAD from kdmsoft solved the problem, I do not give a link, you will find it yourself in Google

[shafiq_adha]

thanks man! you just help me replace 250 tagging in 5 minutes