Creating a custom CSV file using deluge script/

I have an application I have developed and the client wants us to place an export file in csv onto an ftp server daily.

Now I don't see au options in creator to change the separator to anything else. The client wants the separator to be the pipe symbol "|"

I think i would be able to create schedule with some code to create the appropriate data in a string using deluge script but I haven't seen any functionality that would allow me to deposit that data as a file anywhere or attach it to an email at runtime or place it as an attachment to a form record at runtime and then detatch it to a file system. Would this be possible?

My next question would be, is there a way to deposit a file onto an external FTP server

Email a file to a location on an ftp server?

Thanks in advance.