-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
  • 561,645
  • 34
  • 376
  • 476
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,073
  • 146
  • 84
  • 117
js.palus
  • 73
  • 1
  • 9