Hi Richard, What I do is simply use the import external data function in Excel which is under the data menu. Import the csv files as is but specify that the delimiter is a semi colon instead of a comma. This does the job and it is better than modifying the code, well IMHO it is.
Regards Mark "Imagination is more important than knowledge, the important thing is to not stop questioning." -- Albert Einstein > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Richard Hamson > Sent: 21 June 2005 00:28 > To: otrs@otrs.org > Subject: [otrs] Reporting / .csv files > > Hello, > > I am currently looking into setting up reports by exporting .csv file out > of > OTRS. Unfortunately the .csv files are coming out with ; instead of , > between the columns of data thus Excel (in this case) is putting all of > the > information in one column. > > Does anyone know where to amend the syntax so that , are used and not ;? > > Regards > > Richard > > _________________________________________________________________ > Want to block unwanted pop-ups? Download the free MSN Toolbar now! > http://toolbar.msn.co.uk/ > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support oder Consulting für Ihr OTRS System? > => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
