Removing Spaces after | sysmbol

Naveen Kumar

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

PeterJones

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.

Prahlad-Makwana4145

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

@Prahlad-Makwana4145

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

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:

Insert a multi-selection ( Click, Shift + Alt + Down Arrow )
Press the End key
Then, Control + Left Arrow
Finally, press Back-Space.

astrosofista

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:

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

Insert a multi-selection ( Click, Shift + Alt + Down Arrow )

Press the End key

Then, Control + Left Arrow

Finally, press Back-Space.