Remove columns



  • Good afternoon I have a file that has 1457619
    lines

    use the following to add the:
    Find what: ^\S+\h\K
    Replace with: :

    name :0b841fd6f983a161b43dab4f7a7930e98df9b4527f878dbd9 wwww/CEND 2d5f40d00067cf307dae3fbe64f 2016-04-27 01:41:50.228874 65.132225.45.254 Dalvik/2.1.0 (Linuxxx; U; Android 5.0; NXA8QC116 Build/LRX21V) f 1970-01-01 fc0d891c95512da905030f0rrrrrr45d57200acf1bf7f 7204165 false google 7196717 f

    but it doesn’t work with too many lines the regex:^\S+\h\K

    just add to the half of lines approximately

    Then
    para unir el name and :0b841fd6f983a161b43dab4f7a7930e98df9b4527f878dbd9
    use replace

    name:0b841fd6f983a161b43dab4f7a7930e98df9b4527f878dbd9 wwww/CEND 2d5f40d00067cf307dae3fbe64f 2016-04-27 01:41:50.228874 65.132225.45.254 Dalvik/2.1.0 (Linuxxx; U; Android 5.0; NXA8QC116 Build/LRX21V) f 1970-01-01 fc0d891c95512da905030f0rrrrrr45d57200acf1bf7f 7204165 false google 7196717 f

    and finally to be left alone with

    name:0b841fd6f983a161b43dab4f7a7930e98df9b4527f878dbd9

    I have used

    SEARCH: (?-s)\h.+

    REPLACE: EMPTY

    can you help me I just need

    name:0b841fd6f983a161b43dab4f7a7930e98df9b4527f878dbd9

    sorry if I haven’t been able to explain better

    thanks



  • Hello @rovitie and All

    • Open the Replace dialog ( Ctrl + H )

    • Type in the regex \x20(?=:)|(?-s)\x20.+ in the Find what zone

    • Leave the Replace with zone EMPTY

    • Tick the Wrap around option

    • Select the Regular expression search mode

    • Left-click on the Replace All button

    voila ;-))

    Notes :

    • This regex contains two alternatives, separated with the alternation symbol |

      • The \x20(?=:) part looks for a space character ONLY IF  followed with a colon symbol, so catches the space char after the string name

      • Then, the (?-s)\x20.+ part searches for a space character ( \x20 ) , followed with all the remaining chars of current line ( .+ ). Note that the (?-s) syntax forces the regex dot symbol ( .) to represents a single standard character only ( not line-breaks chars as \r or \n )

      • As the replacement zone is EMPTY, anything matched by the search regex is then deleted

    Best Regards

    guy038



  • Hello,@rovitie

    Please try this information,To remove column

    Use Alt+Shift+navigation keys, or Alt+Shift+click to do a block select of just that column. Then simply press Delete.

    I hope this information will be useful for you.
    Thank You.


Log in to reply