Exporting Mysql resutlts into one colunm
Posted on 2011-02-24
i have results sets like this:
123 this is an example line, this is another example line, this is the third example line.
What i would like is this
Customer historytext historytext historytext
123 this is an example line this is aother example line this is the third example line
So that every time on my org example, when there is a comma in the history text, it would move this text into the next cell.
I do not want to write the code usiing the MAX is null expression, as i don't know how many colunmss could be on any one customer, they all vary
Is this possible.
I am using Mysql and had been using the Group_concat function to group all text into one cell.
however when i export it this data will not all show on the cell because of the limits on excel.
Can anyone please help?