Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Can a Macro read an external file?

    General Discussion
    sql
    2
    2
    44
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Murray Sobol 1
      Murray Sobol 1 last edited by

      I have been assigned a project to change several table and column names; we are moving to Oracle 19 and it allows for table and/or column names to be longer than 30 characters (the old Oracle limit). I can produce a spread sheet that maps the “old” table/columns" to their new names. I was thinking of doing this thru a macro but didn’t find a way to read an external file. BTW, I would export the spreadsheet into a comma-delimited file and then I would try to a macro to do the replacements.
      Is this possible or am I just dreaming??
      Thanks

      PeterJones 1 Reply Last reply Reply Quote 0
      • PeterJones
        PeterJones @Murray Sobol 1 last edited by

        @Murray-Sobol-1 ,

        A macro? No, macros can only do internal notepad++ / editor commands (either accessing the text of the active file, or doing notepad++ menu actions)

        If you are willing to do something fancier, there are scripting plugins (like PythonScript and LuaScript) which allow you to write arbitrary scripts in your favorite interpreted language with extra commands that have access to the text in open files and the notepad++ gui/menus.

        1 Reply Last reply Reply Quote 2
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors