i have a problem with a sqlplus (v8) statement that queries several tables and writes the output into a csv file.
that works so far, but one of the tables is a encrypted user password. the problem is that the encrypted characters can also include control characters like LF (line feed) or CR (carriage return)and those shake my csv file completely up.
i have no clue how to quote those characters. is there a trick inside sqlplus, or do i need to solve this problem somehow in the shell script?
any hints welcome