topic Re: File data problem in Application Development and Automation Discussions

File data problem

Former Member — Mon, 09 Mar 2009 10:51:27 GMT

Hi Expetrs,

Using the 'GUI_download' Fuction module I am downlaoding the data in the EXcel file with the tab delimiter.

In the Internal table One filed data like '1020200040102730' after downloading the data into the Excel its showing like '1.0202E+15'.

All ways (after downloading the data) I want the data like '1020200040102730'.

Please suggest me.

Thnx,

Sam

Re: File data problem

Former Member — Mon, 09 Mar 2009 10:58:18 GMT

Hi,

The Excel file to which you are downloading the data:

Select the column to which the specific numeric data will get stored.

Right click on selected whole column > Format Cells > Select 'Text'.

Then Download.

If still the problem persists try passing the numeric data as type char10 char15 whatever.

Regards.

Re: File data problem

Former Member — Mon, 09 Mar 2009 10:58:58 GMT

Define this field as character Field, so at the time of exel download it will give you proper Output

Regards,

Alpesh

Re: File data problem

Former Member — Mon, 09 Mar 2009 11:00:10 GMT

hello,

well the only solution i have found to this problem till now is that you will need to concatenate a character in from of the number: '00000003454484 or format the fields in your excel sheet.

kevin

Re: File data problem

former_member242255 — Mon, 09 Mar 2009 11:00:14 GMT

it is displaying as 1.0202E+15 due to format of the cells inthe excel sheet.

the formt of the cells should be Number ,if it is General it displays like the above.

Re: File data problem

Former Member — Mon, 09 Mar 2009 11:00:42 GMT

Hi Sam,

Please Select the Single Field or the Column you want to convert.

Right Click on them ->Go to Format Cells ->Select the Category Number With Decimals Place '0'.


Then Click on Ok

Thanks

kalyan

Re: File data problem

Former Member — Mon, 09 Mar 2009 11:03:28 GMT

actually the value should be in character format.

this happens with the interger value

if you could place ' ' ' before the value i.e '12345678 in excel

then u'll have no problem

Re: File data problem

Former Member — Mon, 09 Mar 2009 11:12:37 GMT

HI,

In the Excel Sheet, Select the Coloum, Right Click it

Then Secect Number---> The below the Negative Number Part Select 123,10 --> than OK

Then do the downloading ,

This will solve ur problem.

Thanks and Regards'

Suraj S Nair