Community

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

    Removing Spaces after | sysmbol

    General Discussion
    5
    6
    170
    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.
    • Naveen Kumar
      Naveen Kumar last edited by

      aaa|bbb.xxxx_xx| 34617
      aaa|bbb.xxx_xxxx| 7111
      aaa|bbb.xxx_xxxx| 9953
      aaa|bbb.AAAA| 10858
      aaa|bbb.BBBB| 6804
      aaa|bbb.CCC| 53853
      aaa|bbb.LINK_FOLDER| 3004
      aaa|bbb.SERVICEBIXEXTRACT| 19471

      1 Reply Last reply Reply Quote 0
      • PeterJones
        PeterJones last edited by

        If you have Search > Replace set in Normal search mode (or Extended search mode), searching for | (vertical bar followed by space) and replacing with just the vertical bar | will do what you want.

        If you are in Regular Expression search mode, then the | has special meaning, and you have to escape it as \| in the Find what: box.

        You might benefit from reading the official “Searching” document, especially the sections on Extended Search Mode and Regular Expressions.

        1 Reply Last reply Reply Quote 3
        • Prahlad-Makwana4145
          Prahlad-Makwana4145 last edited by

          Hello, @Naveen-Kumar

          Please follow this steps,To Removing Spaces after | sysmbol

          Step 1 :- select all the data (Ctrl+A).
          Step 2 :- Then select Edit>Blank Operation>Trim trilling space.
          Step 3 :- Remove all the spaces in between.
          Step 4 :- Then you could use a simple regular expression search and replace.

          I hope this step will be usefull for you.
          Thank you.

          Alan Kilborn 1 Reply Last reply Reply Quote 0
          • Alan Kilborn
            Alan Kilborn @Prahlad-Makwana4145 last edited by

            @Prahlad-Makwana4145

            I won’t downvote, but I will comment for any future readers that your “solution” doesn’t make any sense.

            1 Reply Last reply Reply Quote 0
            • astrosofista
              astrosofista last edited by astrosofista

              Hi:

              OK, just for the non-regex oriented people in the list, let me suggest you an alternative approach to delete those unwanted blank spaces.

              This little thingy requires the BetterMultiSelection plugin to get the job done, as follows:

              giphy

              In case you couldn’t read the instructions while the gif is playing:

              1. Insert a multi-selection ( Click, Shift + Alt + Down Arrow )
              2. Press the End key
              3. Then, Control + Left Arrow
              4. Finally, press Back-Space.
              astrosofista 1 Reply Last reply Reply Quote 1
              • astrosofista
                astrosofista @astrosofista last edited by

                Sorry people, here is the working link to the animated gif (couldn’t edit it in time):

                https://giphy.com/gifs/eKh1aKIxZOEUB2308F

                @astrosofista said in Removing Spaces after | sysmbol:

                Hi:

                OK, just for the non-regex oriented people in the list, let me suggest you an alternative approach to delete those unwanted blank spaces.

                This little thingy requires the BetterMultiSelection plugin to get the job done, as follows:

                giphy

                In case you couldn’t read the instructions while the gif is playing:

                1. Insert a multi-selection ( Click, Shift + Alt + Down Arrow )
                2. Press the End key
                3. Then, Control + Left Arrow
                4. Finally, press Back-Space.
                1 Reply Last reply Reply Quote 2
                • First post
                  Last post
                Copyright © 2014 NodeBB Forums | Contributors