Community
    • Login

    Double Quotation Marks

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    double quotes
    3 Posts 3 Posters 3.8k 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.
    • Surinder RamS
      Surinder Ram
      last edited by

      Hi,

      I am using notepad++ and checking a file this is consisting of values outputted in the following format : “value”|”Value”|

      I want to search for where a double quotation mark has been inserted in error for example “value””|

      Please can you let me know how can I search for this in notepad++

      Many Thanks

      1 Reply Last reply Reply Quote 0
      • Andy BayleyA
        Andy Bayley
        last edited by

        What do the vertical lines in your examples indicate? Would searching for “” find the double set in your first example and in your second example? Is there a way to distinguish between the two examples?

        1 Reply Last reply Reply Quote 0
        • guy038G
          guy038
          last edited by guy038

          Hello, Surinder Ram,

          In your example, below, do you mean that the separator values is the real VERTICAL LINE, of Unicode value \x007C ?

          "Value_1"|"Value_2"|"Value_3"....
          

          If so, I suppose that you would like that :

          • The syntax ""| would be changed into "|"

          • The syntax |"" would be changed into "|"

          • The syntax "" would be changed into "|"

          • The syntax "| , NOT followed by a double quote mark, would be changed into "|"

          • The syntax |" , NOT preceded by a double quote mark, would be changed into "|"

          • The syntax |, NOT surrounded by two double quote marks, would be changed into "|"

          • And, if any of these syntaxes, above, are found at the end of the current line, it would be changed into a single final double quote mark (")

          • And, also, when the normal separator form "|" or NO separator, at all, is found, at end of the current line, it would be changed into a single " character


          In that case, just follow the few steps, below :

          • Go back to the very beginning of your file ( Ctrl + Origin )

          • Open the Replace dialog ( Ctrl + H )

          • In the Find what zone, type (?:(""\||\|""|""|(?<!")\|"|"\|(?!")|(?<!")\|(?!")|"\|")|(?<=[^"|\r\n]))(?=(\R))|(?1)

          • In the Replace with zone, type (?2":"|")

          • Click on the Replace All button

          Et voilà !


          So, from the original example, below, where :

          • Only, values 7 - 8 AND values 8 - 9 are correctly separated, on each line

          • The value9 is correctly ended, in the first line, only

            value1"“|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”
            value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9|””
            value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9"”|
            value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9"”
            value1"”|value2|““value3"“value4”|value5|“value6|value7”|“value8”|“value9|”
            value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”|
            value1"”|value2|"“value3"“value4”|value5|“value6|value7”|“value8”|“value9|
            value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9
            value1"”|value2|”“value3"“value4”|value5|“value6|value7”|“value8”|“value9”|”

          After that S/R, the different separators would be changed and the different values correctly separated, as below :

          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          value1"|"value2"|"value3"|"value4"|"value5"|"value6"|"value7"|"value8"|"value9"
          

          If this S/R ,just, solves your problem, next time, I’ll explain the regexes used !

          Best Regards

          guy038

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