Shell Programming and Scripting

Yes, of course - if you answer my question.

Dear RudiC,

It is taking from database and then storing in a file like Integer format.
its like date and time are concatenating and then pushing into flatfiles.

Regards,

Try - if your shell provides "process substitution" -

Code:

date -f<(sed -r 's/([0-9]{8})([0-9]{2})([0-9]{2})([0-9]{2})/\1 \2:\3:\4/' file)  "+%s"
1538666471
1538666473
1538666473
.
.
.

or

Code:

sed -r 's/([0-9]{8})([0-9]{2})([0-9]{2})([0-9]{2})/\1 \2:\3:\4/' file | date -f- "+%s"

Thanks RudiC,

One more help please, how can we set the above command for the value instead of file like 20181007130640

Regards,

I don't understand. Please rephrase.

Code:

 sed -r 's/([0-9]{8})([0-9]{2})([0-9]{2})([0-9]{2})/\1 \2:\3:\4/' file | date -f- "+%s"

like for

Code:

sed -r 's/([0-9]{8})([0-9]{2})([0-9]{2})([0-9]{2})/\1 \2:\3:\4/' 20181007130940 | date -f- "+%s"

Kindly tell us what operating system and shell you're using. (Which, as you know, you should tell us every time you start a thread in the Shell Programming and Scripting forum.)

With a POSIX conforming shell, you can easily use various variable expansions to get parts of a string and assignment to assign the reformatted data into another variable. With a csh derived shell, your options might be more limited.

With awk, you can easily use substr() and print or printf or sprintf (depending on what you want to do after that).

What have you tried to solve this problem on your own?