1

I'm converting a timecode and need to replace a colon with a full stop - 00:00:00:000 needs to become 00:00:00.000

I've not used Wildcards before, but gave it ago with no success. What would I have to enter to just replace the last colon, as above?

Thank you!

Kinyonga
  • 13
  • 3
  • [Finding and replacing characters using wildcards](https://wordmvp.com/FAQs/General/UsingWildcards.htm) – DavidPostill Jan 17 '21 at 00:37
  • Thanks for the link! I've tried doing :([0-9]{3}) to specify I want the colon followed by 3 numbers replaced by a full stop, except that deletes the following numbers too. How do I just replace the colon? – Kinyonga Jan 17 '21 at 10:02
  • You are almost there. Search for `:([0-9]{3})` and replace with `.\1`. Read https://wordmvp.com/FAQs/General/UsingWildcards.htm#Theory8 – DavidPostill Jan 17 '21 at 10:16
  • Fantastic, got it now, thank you :) – Kinyonga Jan 17 '21 at 10:19

1 Answers1

0

00:00:00:000 needs to become 00:00:00.000

Use the following:

  • Find :([0-9]{3})

  • Replace .\1

Source: Finding and replacing characters using wildcards

DavidPostill
  • 153,128
  • 77
  • 353
  • 394