Results 1 to 4 of 4

Thread: Search in excel and replace text in AutoCAD

  1. #1
    Member
    Join Date
    2007-09
    Posts
    2
    Login to Give a bone
    0

    Question Search in excel and replace text in AutoCAD

    Hi,

    I have excel containing three columns : AutoCAD Filename, Oldtext, newtext
    I need following functionalities:
    1. Open AutoCAD file
    2. Find oldtext corrosponding to filename
    3. Replace with newtext

    I am able to create replace text function, replace text in a block. Now stuck up to read excel values.

    Any hints/code snippet will be appreciated!

    BR
    Nil
    Attached Files Attached Files

  2. #2
    Certifiable AUGI Addict
    Join Date
    2001-03
    Location
    Tallahassee, FL USA
    Posts
    3,658
    Login to Give a bone
    0

    Default Re: Search in excel and replace text in AutoCAD

    Try this Lee Mac lisp instead: http://www.lee-mac.com/bfind.html

  3. #3
    Login to Give a bone
    0

    Default Re: Search in excel and replace text in AutoCAD

    Hello, I used the "BFIND" lisp from lee Mac and it works well, but my concern is that I have a lot of texts to replace, of course the lisp does that but it does it text by text, and I have a list of 17000 texts to replace by searching for the value of the old text and replacing it with the new text in the files select "* .dwg" without opening them, how to add the list without entering one by one, thank you

  4. #4
    All AUGI, all the time
    Join Date
    2003-07
    Posts
    555
    Login to Give a bone
    0

    Default Re: Search in excel and replace text in AutoCAD

    If you make a csv file it should be easy to incorporate into using Bfind. Again Lee-mac has a parse csv to list.

Similar Threads

  1. Have a "Replace All" option with the "Save and Replace" Feature
    By Wish List System in forum Inventor Wish List
    Replies: 0
    Last Post: 2017-11-01, 05:10 PM
  2. Autocad search & replace text
    By MarkLyon in forum CADmep General
    Replies: 1
    Last Post: 2012-11-05, 10:03 AM
  3. Text search and replace
    By revit.wishlist1942 in forum Revit Architecture - Wish List
    Replies: 1
    Last Post: 2008-12-23, 03:06 PM
  4. AUGI Forums Search facility now uses MySQL Full Text Search
    By Mike.Perry in forum Forum Tips & Tricks (Read only)
    Replies: 0
    Last Post: 2008-01-28, 09:36 AM
  5. Text search and replace routine across multiple drawing files
    By David van Erk in forum AutoCAD Customization
    Replies: 1
    Last Post: 2006-05-19, 10:31 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •