-1

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!

Wiktor Stribiżew
  • 607,720
  • 39
  • 448
  • 563
Tal Nahum
  • 26
  • 3

1 Answers1

0

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.

Pang
  • 9,564
  • 146
  • 81
  • 122
js.palus
  • 83
  • 1
  • 10