Replace name VID20231001100715 to 2023-10-01 - 10.07.15

Very good to everyone,

I hope you can help me. When I travel in a country with a different time zone, my mobile phone gives me incorrect metadata regarding the time the videos were made. The only place where it puts the correct time is in the file name itself. An example would be the following:

VID20231001100715

What I want is to convert it to this format:
2023-10-01 - 10.07.15

I have tried, but I have not been able to find the correct formula to replace said name and convert it with the desire. Help me please :')

Reply to #1:
Ill try to help you.
With the ADD method you can add - and . in the position you want. This should be done 5 times.

You can also use Regular Expression with the REPLACE method.

TEXT TO REPLACE: VID(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})
REPLACE WITH: VID-$1-$2-$3 - $4.$5.$6
Select Use Regular expressions

If you don't want to use VID then use REPLACE WITH: $1-$2-$3 - $4.$5.$6

https://i.ibb.co/Njy1Yv0/Captura-12-02-2024-34s. png

Miguel

Reply to #2:

WORKS! You are incredible, you have saved me from being able to continue having the images and videos organized.

Thank you very much again, you are not aware of the help you have given me :D

Reply to #3: Glad to help you.

Miguel