• Login
Community
  • Login

Remove the text contained in quotes with notepad

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
3 Posts 2 Posters 1.2k Views
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.
  • A
    AndrewJor
    last edited by AndrewJor Oct 29, 2018, 4:22 AM Oct 29, 2018, 4:22 AM

    Greetings to all friends, I hope you can help me, I have a text (25908 lines) with quotation marks, please see the example:

    = “create” + “tablespace” + “ts1” + “datafile”

    I need to modify it to the next text

    = “database” + “tablespace” + “ts1” + “datafile”
    = “create” + “database” + “ts1” + “datafile”
    = “create” + “tablespace” + “database” + “datafile”
    = “create” + “tablespace” + “ts1” + “database”

    You are the teachers, I hope you help me
    Thank you

    1 Reply Last reply Reply Quote 0
    • G
      guy038
      last edited by guy038 Oct 29, 2018, 7:13 PM Oct 29, 2018, 10:09 AM

      Hello @andrewjor and All,

      If I’m textually understand your example, your have a text, with 5 words :

      = "create" + "tablespace" + "ts1" + "datafile"   “database”
           1            2           3         4            5 
      

      And you would like to transform the unique line :

      1 + 2 + 3 + 4
      

      into the four lines text, below, with the word 5, shifted, in each line, wouldn’t you ?

      = 5 + 2 + 3 + 4
      = 1 + 5 + 3 + 4
      = 1 + 2 + 5 + 4
      = 1 + 2 + 3 + 5
      

      Indeed, t’s easy to notice that you expect :

      • Word 5 to be the first word in line 1, instead of word 1
      • Word 5 to be the second word in line 2, instead of word 2
      • Word 5 to be the third word in line 3, instead of word 3
      • Word 5 to be the last word in line 4, instead of word 4

      BTW, I suppose that the double quote, surrounding the different words of your text, are the classical one " ( of code \x{0022} ) and not the “ and ” quotes ( with code \x{201c} et \x{201d} )

      In that case, and considering the sample text, below, with your 4 words followed with a fifth one, which is to be added in each line :

      = "create" + "tablespace" + "ts1" + "datafile"   “database”
      

      SEARCH (?-s)(".+?").+(".+?").+(".+?").+(".+?").+(".+?")

      REPLACE \5 + \2 + \3 + \4\r\n= \1 + \5 + \3 + \4\r\n= \1 + \2 + \5 + \4\r\n= \1 + \2 + \3 + \5

      It would be replaced as below :

      = "database" + "tablespace" + "ts1" + "datafile"
      = "create" + "database" + "ts1" + "datafile"
      = "create" + "tablespace" + "database" + "datafile"
      = "create" + "tablespace" + "ts1" + "database"
      

      Of course, it’s my first attempt which will, probably, need adjustments :-))

      Cheers,

      guy038

      A 1 Reply Last reply Oct 30, 2018, 4:45 AM Reply Quote 1
      • A
        AndrewJor @guy038
        last edited by Oct 30, 2018, 4:45 AM

        @guy038
        Mister guy038, my sincere thanks for your help, the code helped me a lot, went out to perfection

        1 Reply Last reply Reply Quote 1
        2 out of 3
        • First post
          2/3
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors