How to replace from second occurrence

0

My data looks like this:

Name,Minutes,Meters
ABILENE TX - CHARLESTON SC - ABILENE TX - CHARLESTON SC,1162,2052516
ABILENE TX - CHARLESTON WV - ABILENE TX - CHARLESTON WV,1153,2029119
ABILENE TX - LAFAYETTE IN - ABILENE TX - LAFAYETTE IN,1040,1809812

I need to replace from the second hyphen to the first comma, with only a comma. I'm using Textpad.

I want it to look like this:

ABILENE TX - CHARLESTON SC,1162,2052516
ABILENE TX - CHARLESTON WV,1153,2029119

Kyle969

Posted 2015-03-12T14:08:57.057

Reputation: 1

Your question might be clearer if you also show an example of what you'd like to see. – Tim Radcliffe – 2015-03-12T15:42:28.223

Answers

0

I accomplished this by replacing

|\n[^\-]*\- |

with

\n

and running it twice.

Kyle969

Posted 2015-03-12T14:08:57.057

Reputation: 1