Re: PHP to Excel (csv)

Thank you for your help. Ivo "Ivo Stoykov" <ivostoykov@hotmail.com> wrote in message news:20021008061402.87364.qmail@pb1.pair.com... > Hi > > I have following problem. > > Some data retreived from mysql db I need to send to the user as a *.csv > file. Usually I separate fields (usually double quoted) with comma (,) or > semicolomn (;) and the records with cr/lf (Windows) > It works fin until I do not have cr/lf in any of the fields. > > Unfortunately the last field is TEXT type and may have more that one cr/lf > inside (as data). When this is the case the *,csv file cannot be open > correctly in Excel. If there are cr/lf in any field it is split in Excel as > a separate row and the record structure is broken.\ > > Any idea how could solve this? Thank you > > Ivo > >