How to append sysdate to .CSV file inunix and remove them

mv file_name.CSV file_name_$(date "+%Y-%m-%d").CSV

If you plan to put the above directly (not inside a script) into the crontab please be aware that you'll have to escape the percent signs with a backslash ("\%").

Hi,

While executing any command at any operating systems follow:
          Use full path of the command (since alias or functions can overwrite the actions it is performing)
Hence here goes related commands:
1. using back tick
/bin/mv -i file_name.CSV file_name_''`/bin/date "+%Y-%m-%d"`''.CSV
2. As per message from woolmilkporc including full path:
/bin/mv -i file_name.CSV file_name_$(/bin/date "+%Y-%m-%d").CSV

Handling exception to overwrite existing file"
1. /bin/mv -i file_name.CSV file_name_''`/bin/date "+%Y-%m-%d"`''.CSV
2. handling file name using hour/min/second/nanoseconds....

#!/bin/ksh
CurFile=''`/bin/ls -ltr file_name*.CSV | /usr/bin/tail -1 | /bin/awk '{ print $N
F}'`''
/bin/sleep 1
NextFile="file_name_"''`/bin/date "+%Y-%m-%d_%h_%M_%S__%N"`''".CSV"
if test -f $CurFile
then
        echo File $CurFile is present
        echo hence moving in following format
        echo file_name_YYY-mm-dd_hr_min_sec_Nanosec.CSV
        /bin/mv -i $CurFile \
        $NextFile
        echo if
else
        CurFile=file_name.CSV
        if test -f $CurFile
        then
                /bin/mv -i $CurFile \
                $NextFile
        else
                echo $$CurFile file not found
        fi
fi

Select allOpen in new window

Problem solved
 thanks for your support and help

Hi Pothina_info,

welcome for the same. You can provide assisted/accepted solution for the same.

Regards,
Murugesan

Hi Pothina_info,

Previous comment posted on on 2016-05-20.
Waiting for accepted or assisted solutions.

cmd.exe /c ECHO %DATE% | find "2016"
25-05-2016

Regards,
Murugesan