Search code examples
excelnotepad++

how can i delete two chars before - in notepad++


I have database that organize this way

now - 14-17 , 16-20 , 1-12 , 10-1

i want it to be like

after - 17, 20 , 12, 1

thanks!


Solution

  • In Notepad++, in the search replace select regular expression and put the following in "Find what":

    [0-9]*-
    

    and put a blank in the "Replace with" as in the picture below:

    result will be:

    17 , 20 , 12 , 1
    

    That should do the trick.