How to change the timing format
Thread poster: Natalie
Natalie
Natalie  Identity Verified
Poland
Local time: 08:03
Member (2002)
English to Russian
+ ...

MODERATOR
SITE LOCALIZER
Aug 18, 2020

Hi everybody,

Does anybody know how to batch-replace the timing from the "00:00:48,660" format to just "00:00:48"?

The timing was exported from Aegisub in this format, but I need to paste it in the simple format into the XLS worksheet provided by the client.

Many thanks in advance!


 
James Plastow
James Plastow  Identity Verified
United Kingdom
Local time: 07:03
Member (2020)
Japanese to English
regex Aug 18, 2020

I think you need a regular expression.

\d means any number

( ) means "name what is inside the brackets group 1"

$1 means "insert group 1"

So,

Find: (\d\d:\d\d:\d\d),\d\d\d

Replace: $1

I haven't tested this but I think it should work


 
Natalie
Natalie  Identity Verified
Poland
Local time: 08:03
Member (2002)
English to Russian
+ ...

MODERATOR
TOPIC STARTER
SITE LOCALIZER
Alas Aug 18, 2020

Thank you for the suggestion, James, however, it does not work.

What am I doing wrong?


 
James Plastow
James Plastow  Identity Verified
United Kingdom
Local time: 07:03
Member (2020)
Japanese to English
sorry Aug 19, 2020

Sorry, it seems Excel doesnt support regular expressions.
It will work in Google Sheets or Trados.


 
Natalie
Natalie  Identity Verified
Poland
Local time: 08:03
Member (2002)
English to Russian
+ ...

MODERATOR
TOPIC STARTER
SITE LOCALIZER
Replaced in Notepad++ Aug 19, 2020

and pasted into Excel - it worked like a charm.

Many thanks for your help, James!


James Plastow
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Laureana Pavon[Call to this topic]

You can also contact site staff by submitting a support request »

How to change the timing format






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »