Hi, I am adding a screen shoot here by to explain how you can solve this issue
Actually sysaid exports the data fine, this is more of a view/field translation issue
When you export using office, the csv file opens up in excel , by default you see multipull rows (line feed between) as one raw
Example : on the description in the attached screen shoot I made
Service request 113 and 114 where sampled on the description field with:
Test1 and 1 line feed 2 line feed 3....etc...(113) ,
and test2 and 1 line feed 2 line feed 3....etc... (114)
Actually you will see on the export initially (in the excel example) under description on 113 : test1 only! , and on 114 : test2 only! (Under the description value)
If you will follow my explanation you will solve this quite quickly :
With office (Microsoft and excel) :
on the screen shoot 1. Mark the upper triangle this will paint horizontal + vertical 2. Between rows 1 and 2 point your mouse marker and double click it
This will open up the rest of the values (which were "hidden" from you before)
With open office : note marking the check boxes opening up before the table generates
Mark : coma + space > proceed
This will solve this issue
Then.... you can resize your colmons at free will to best suite your wishes (offcourse save the document)
Hope this helps you
|
| Filename |
line feed.jpg |
|
| Description |
|
| Filesize |
303 Kbytes
|
| Downloaded: |
7 time(s) |
This message was edited 2 times. Last update was at 02/10/2011 17:50:54
|