Removing Spaces after | sysmbol



  • 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



  • 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.



  • 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.



  • @Prahlad-Makwana4145

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



  • 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.


  • 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.

Log in to reply