How to Replace a character at a specific position

[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.

[therube]

I'm not quite understanding your post, but see if this works?

1:RegEx

Code: Select all

Match:  (.*)\^(.*)
Replace:  \1-\2