Posted by mark.heyden on 02/02/06 09:49

Hi Frends,

I am facing problems while trying to export data into
pipe format. In fact I am fetching records from mysql database and then
trying to create a text file ( using pipe as delimeter) , intending to
open in Excel.

The data is been inserted from textarea fields, where the
user can write text and may press enter key to format his text
accordingly. Now when the data entered into the database it keeps some
unidentified value so as to keep the formatting. Hence while displaying
the text file I find that lines are seperated according to the format
user gave. Thus creating the problem while opening up in the excel
file.

example:

First Name: Mark [Text Field].
Second Name: Heyden ]Text Field].
Address: xyz (Enter Key pressed)
abc, (Enter Key pressed)
def. (Enter Key pressed)
[TextArea]

Hence the record I expect should be in the text file like,

Mark | Heyden | xyz abc,def.

But I am getting it as

Mark | Heyden | xyz
abc,
def.
I would appreciate if some one can give me the solution
how i can get rid of the situation.

Thanks,
M Heyden.

• Next in forum: Re: I need help with very complex query
• Prev in forum: Re: Returning from an included script while inside a function ?
• Thread view: Problems while exporting data using pipe symbols

[Reply to this message]