saradhissrv
Technical User
Hi
I had the following issue.
I need to generate a Tab delimited report, the user will view the
data in Excel and will upload the data to his legacy system.
I had generated the Tab Delimited Report using
(DESCFORMAT='DELIMITED') and it worked very fine when tested
through report builder output file.
If i had run the report in APPS using concurrent program output
file will be opened in iexplorer and the user will save the file
as txt, then he tries to open the same in Excel. The problem here
is the Excel is not recognizing the TAB delimiter and not breaking
the columns, all the columns are fetched to single COLUMN of
excel.
Is there any solution for the same.
Regards
I had the following issue.
I need to generate a Tab delimited report, the user will view the
data in Excel and will upload the data to his legacy system.
I had generated the Tab Delimited Report using
(DESCFORMAT='DELIMITED') and it worked very fine when tested
through report builder output file.
If i had run the report in APPS using concurrent program output
file will be opened in iexplorer and the user will save the file
as txt, then he tries to open the same in Excel. The problem here
is the Excel is not recognizing the TAB delimiter and not breaking
the columns, all the columns are fetched to single COLUMN of
excel.
Is there any solution for the same.
Regards