Sitemap

Amicuk Programming Answers

How to keep the real data if number length bigger than 15 in excel format

-0001-11-30   Views:0

Advertisement

i have a bank card number column in report, the data type is varchar , and the data is always number , the length is bigger than 15, now if i download the report as excel format, this column's data will alwasys change to something like "5.41321E+17&q

i have a bank card number column in report, the data type is varchar , and the data is always number , the length is bigger than 15, now if i download the report as excel format, this column's data will alwasys change to something like "5.41321E+17", and due to this, i just format this column to custom=0, but all data will change the last number to "0" like "460025198509180000", this is what i do not wanted.
how to solve this problem? thanks in advance
Kaymo
Edited by: user10740102 on Jun 11, 2009 1:23 AM

The replay answer
Advertisement
it's because Excel is thinking that it's a number....try changing the formula for the column from Table.ColumnName to the following
'"'||Table.ColumnName||'"' (or use CONCAT - it's the same)
This will show quotes and when you download to excel - it'll drop the quotes and keep the number

Go to See the other 2 answers

How to keep the real data if number length bigger than 15 in excel format

Category:DefaultRelease time:-0001-11-30Views:130

i have a bank card number column in report, the data type is varchar , and the data is always number , the length is bigger than 15, now if i download the report as excel format, this column's data will alwasys change to something like "5.41321E+17&q[More]

Download data from memory to Excel format.

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus,     How can I download data from Memory( not in application server ) to Excel format ? Now I am using below function modules  but not coming in proper format. CALL FUNCTION 'LIST_FROM_MEMORY'        TABLES             listobject = listobjec[More]

Automatically mailing the table data in excel format in ADF

Category:DefaultRelease time:-0001-11-30Views:130

Hi , I am new to ADF and I have a requirement where i need to send a mail on button click with an attachment of the table data in a excel format. There are two requirements here : 1) If we take an example of EMP and Dept tables , a mail should be sen[More]

Issue with the Data Type 'Number' in Business Objects

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have an Object in the Universe where the Data Type of the Object is a number. This Column pertaining to this Object has certain values in the database out of which there is a 17 Digit Value which is 00000000031101165. Now, when trying to retrei[More]

Issue with field data type NUMBER(22,5) while updating field data.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a field with data type NUMBER(22,5). While inserting or updating field data it should take 17 digit and after decimal point 5 digit total 22 digit. I set 22 for maximumLength property of messageTextInput field. While updating field I am ge[More]

Help needed in converting date to number

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to execute the below query, its failing with "invalid number" error. select * from process_status where time_process > to_char('&3','yyyymmdd') time_process is the "number" datatype. Details: SQL> select * fro[More]

How to convert exponential data into number for the downloaded excelsheet

Category:DefaultRelease time:2015-10-11Views:130

Hi I have downloaded one field data i.e. having char of 50,  into excel sheet and it is displaying as  exponential in the excel sheet.  The data numbers should display as text only i.e 1236547896321 and not exponential Is anyone can tell how we can d[More]

How to get the Data Record Number in BI 7.0?

Category:DefaultRelease time:2015-10-11Views:130

Hi All, In our requirement we need to load the Data Record Number in the DSO. I got the Request ID and Data Packet Number but not the Data Record Number. Does anyone has any idea?Hi...... When the data is activated in DSO, it is written to the table[More]

Date and number display format

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I am new to Adobe Form, and I am quite unimpressed with how difficult it is to do the most simple things. I have managed one way or another to solve all my problems until now, but this one got me stuck. I have date and number fields in my[More]

Need help in date to number conversion

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a doubt in a date conversion, please help me. I executed the below query, its throwing "invalid number" error. select * from test where date_sid between to_number(to_char('01-05-2009','dd-mm-yyyy'),'yyyymmdd') and to_number(to_char('0[More]

Date to Number

Category:DefaultRelease time:2015-10-11Views:130

I have to store year and date in a database column like 'yeardate number(6)'. I have the year and month being passed to my procedure in a number and character strings respective. Month's value is like 'MARCH' i.e. a string, and year value is like 200[More]

Hot
I have been using Adobe Acrobat Standard 9.4.5 for about 2 years to scan and archive documents.  Usually, I scan a stack of invoices then select pages by clicking on the first one, then holding down the control key and selecting additional pages.  Su [More]
Is there a way to detect the size of the attached file in the browser side, before to send this file to a servlet? If yes, how to?Yes u can do that pls check this and let me know... did it serve the purpose <HTML> <HEAD> <SCRIPT> functio [More]
Hi all, I have access to new PI 7.1 Installation Box. When I am aceessing the box with URL http://<boxname>:50000/rep, I see Enterprise Service Buider and Service Registry. Now 1) How do I serach for defualt Enterprise Services which comes with defa [More]
im trying to get cloud installed and not having any luck...I think I have to up grade my operating system but not sure how to that there is nothing under general setting for upgrade .If you only have iOS 4.x (Settings>General>About>Version) then [More]
I am buying a new iMac to replace my 4 year old iMac. I want  want to transfer everything from my old iMac to the new one. My question is which transfer method is best, Target disk or Time Machine? Am not sure of exactly what happens when I connect t [More]
I'm trying to convert .cpi files to .mov? Any feedback on Bigasoft software?Chris CA wrote: How can it be named "sound converter" when it doesn't convert anything? You mean it doesn't convert your .xm file. It works and converts many other files [More]
Using adobe acrobat 7.0 professional on mac. I scanned something recently, saved it as a pdf. Upon the first time saving (every time with first save of new document) I had the options. To save as 5 version or later all that stuff! Once it has been sa [More]
I have a table with about 10 fields to store info for customers. Over time as we have added more customers that table has grown to about 14 million rows. As the data comes in a service constantly inserts a row into the table. 90% of the data is not r [More]
Hi, I wrote a simple program to help me learn about using locales and currency in java. The program worked file for the default locale, but gives an exception when I pass it a US locale. I expect this is something very simple that I've done wrong but [More]
Hi all We're using a vendor repository that contains a qualified table about company code information. We use the standard xsd file (CREMDM) for export the master data to R3, but we want to duplicate the information (segment E1LFB1M) as many times as [More]