How to rename Unix Time Stamp to date time format?

Bingman · 2021-06-21 05:42

I have some files named as:

1621184624 - xxxx.jpg

...

I just want to replace the time stamp to date time, like:

2021-05-16 - xxxx.jpg

I have already searched the 'timestamp', but not seeing anything related to what I'm trying to do.

In addition, I am not familiar with the 'Pascal Script', so would like to ask help from here,

thanks.

eR@SeR · 2021-06-21 10:38

Hi,

Please try following Pascal Script rule if works for your files:

var
  DateTime: TDateTime;
  Parts: TStringsArray;

begin
  Parts := SubMatchesRegEx(WideExtractBaseName(FileName), '(162\d+)(.+)', false);
  If (Length(Parts) <=0) then exit;
  DateTime := UnixToDateTime(StrToInt64(Parts[0]));
  FileName := FormatDateTime('yyyy-mm-dd', DateTime) + Parts[1] + WideExtractFileExt(FileName);
end.

Bingman · 2021-06-21 11:13

eR@SeR wrote:

Hi,

Please try following Pascal Script rule if works for your files:

var
  DateTime: TDateTime;
  Parts: TStringsArray;

begin
  Parts := SubMatchesRegEx(WideExtractBaseName(FileName), '(162\d+)(.+)', false);
  If (Length(Parts) <=0) then exit;
  DateTime := UnixToDateTime(StrToInt64(Parts[0]));
  FileName := FormatDateTime('yyyy-mm-dd', DateTime) + Parts[1] + WideExtractFileExt(FileName);
end.

Wow, awesome，it works！Very appreciate！

seems that I need to learn some programming, LOL!

And I have a small question：

If the beginning is not 162, but other numbers, how to deal with it？

As shown in the figure, i have many files of different years.

timestamp

eR@SeR · 2021-06-21 11:22

You're welcome. Replace '(162\d+)(.+)' part in line 6 with '(\d+)(.+)' i.e. just remove 162 and it should work

Bingman · 2021-06-21 11:27

eR@SeR wrote:

You're welcome. Replace '(162\d+)(.+)' part in line 6 with '(\d+)(.+)' i.e. just remove 162 and it should work

Thanks buddy, big help!

eR@SeR · 2021-06-21 11:31

I'm not sure if there is Unix timestamp format in Reformat Date rule. If not, maybe it can be added

Bingman · 2021-06-21 11:51

eR@SeR wrote:

I'm not sure if there is Unix timestamp format in Reformat Date rule. If not, maybe it can be added

I don't know much about timestamp, but the date after conversion is right,

Last edited by Bingman (2021-06-21 11:52)

den4b Forum

#1 2021-06-21 05:42

How to rename Unix Time Stamp to date time format?

#2 2021-06-21 10:38

Re: How to rename Unix Time Stamp to date time format?

#3 2021-06-21 11:13

Re: How to rename Unix Time Stamp to date time format?

#4 2021-06-21 11:22

Re: How to rename Unix Time Stamp to date time format?

#5 2021-06-21 11:27

Re: How to rename Unix Time Stamp to date time format?

#6 2021-06-21 11:31

Re: How to rename Unix Time Stamp to date time format?

#7 2021-06-21 11:51

Re: How to rename Unix Time Stamp to date time format?

Board footer