As, i need the date at the end of the name of the export flat file, i used the date function to get the date in the format i need.
Now, they need a .txt file with space delimiter. I have tried that by just changing ".csv" to ".txt". Then, the output file is forming, but when i open the output file with a wordpad, the data is unreadable. Whereas when i open the same file with excel, it is showing the data.
My question is how to define the space delimiter? I have tried it by giving ".txt", (txt, delimiter is " ")