07-14-2008 1:21 PM
Dear All,
when i try to download values to excel,
if the field is of type string in the database table and fulstops(.) are used in the values, then even if there are more fields in the row, the data next to the fullstop is being displayed in the next row in the excel.
for example there are 4 fields and second field value is 'xyz abc....', then the third and fourth fields are being displayed in the next row in the excel sheet.
how to resolve this?
thanks in advance.
07-14-2008 1:26 PM
Hi Sharmila,
There is something callled a Delimiter in excel. Check where you need to break the Statement and download the values to excel. This is found in the data tab of excel. You can set the Delimiter there you have an option of previewing your data there.
Regards,
Sai