I have some vba code that generates text files for upload on our linux based system. These files will not load unless they are converted to unix format. I have used 'set ff=unix' in vi and then the files are fine. (thanks question Q_20787617)
Problem is I don't want to have to do this for all files. Is there any way of generating the files in the right format from the off. I'm using access VBA with the command
Print #1, "0" & "," & f1 & c & f2 & "," & f3 & "," & f4 & "," & f5 & "," & ","
Wrong area I know but this seems to be a common problem.
Failing that what about a way of converting all the files in a directory.
PS I'm new to linux and pretty thick