I am getting a file from database using shell script. Data looks like below after running shell script.This is a pipe separated data file.
After generating the file using spool, below is the command that I am running to format the data.
sed -i -E 's/[[:blank:]]+(||$)/\1/g' Test.txt.
but the problem is date data
2017-09-2900:00:00, I need this like
I need space between date and time. How this can be done?