Page 1 of 1

How to Replace a character at a specific position

PostPosted: Tue Dec 19, 2017 5:38 pm
by danmitch1
Hi there, New to posting but frequent reader.
Love the tool, thanks for creating it !

So my question is exactly as the title reads, how can I replace a character at a specific position.
I have a list of employees (thousands)
Example:

D Souza^ Jamie^ 832897
Dompierre^ Jean^ 838551
Donato^ Vittoria^ 831683

I need to keep the first " ^ " but i need to change the second to a " - ".
I know I can insert at position -8 a character but the " ^ " will still remain.
Any ideas?

Thanks in advance for reading !

Dan.

Re: How to Replace a character at a specific position

PostPosted: Tue Dec 19, 2017 6:44 pm
by therube
I'm not quite understanding your post, but see if this works?

1:RegEx
Code: Select all
Match:  (.*)\^(.*)
Replace:  \1-\2