From: <Mar...@dp...> - 2004-08-18 07:11:15
|
Jim, et al I have used the export ability successfully to produce a csv file. However, part of the requirement is to provide a list of items (in this case licence types) that relate to an individual. The no. of licence types may vary but they want the data separated so that it appears separated the same as the rest of the fields. I have a pl/sql procedure which does this and I can invoke it using a user column. But when the data is extracted Datavision recognises that it is a single field with the separator embedded in it and double quotes the field. e.g. Mailing_name,Address_line_1,Address_line_2,Suburb,State,Postcode,Rec_certificate_number,Season_end,Issue_date,Date_of_birth,Licence_string ACER COMPUTER,34 ROAD,,HOBART,TAS,7000,AA1305,31-Oct-2004,22-Jul-2004,01-Jan-1974,"Abalone Dive Licence,Beach Seine Licence,,,,,,,," I want to stop this behaviour in this instance. Is this possible? |