[Solved] Libre Calc Date Conversion

[NotLeftBehind]

I have a spreadsheet with a lot of file names like:
Annual gathering [1999].mov
Annual gathering charity [1999].bmp
Christian charity BBQ (2019).mp4

Different file formats. Different enclosures for dates.

Is there a formula/method I can use to take the date out of column A and copy it in column B, opposed to me just typing them in cell by cell?

Thank you.

[karolus]

Hallo
There ar no valid Dates, only year-numbers.

Code: Select all

=MID(A1;SEARCH("(19|20)[0-9]{2}";A1);4)

you need probably →→Tools→→Options→OO-calc→calculate→[x]enable regular Expressions in Formulas

[NotLeftBehind]

Yes, just years in this case. That is what I meant by dates.

That formula worked! Thank you so much.