| Author |
Message |
    
Netman
Pilla Bewarse
Username: Netman
Post Number: 213
Registered: 03-2004
Posted From: 59.93.115.116
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 6:08 pm: |
|
Vkishore:Work avutundi ...kani it would mean him editing 2000 rows of data untill and unless append function vadukunte tappa...still messy to format the data that way...
meeru cheppindi work avutundi. But aa data 'text type' laaga undi. edanna value zeroes tho start ayite (ex. 00456), mundala zeroes potayi number format cheste.
data excel loki import chese munde, aa particular column ni 'text' ga format cheste 2000 rows ni edit cheyya valasina problem radu. |
Vkishore
Pilla Bewarse
Username: Vkishore
Post Number: 70
Registered: 10-2011
Posted From: 149.199.62.254
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:55 pm: |
|
Netman:number mundu apostrophe (') add cheste aa problem povachchu
Work avutundi ...kani it would mean him editing 2000 rows of data untill and unless append function vadukunte tappa...still messy to format the data that way... |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18158
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:53 pm: |
|
Netman:number mundu apostrophe (') add cheste aa problem povachchu
ste ba cheppindi work ayyindi annai.column mothanni select chesi format cell ani number select chesi 0 decimal places annanu..it converted that to correct value or if any of the cells has any alphanumeric values also, that value is intact. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18157
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:52 pm: |
|
Fanno1:mama usual gaa alane vuntayi kadaa.
nee second question ardham kaaledhu. u mean nee value C67158500000000 ani vundhaa
ledu mama..anni numbers ga undali like 67158500000000. I am converting the .xls file to .csv and loading in to a stage table. this is employee bank info and I use that stage data to update the bank info of the employee's using Oracle api's
Vkishore: Out of curiosity one question mama....SQL nunchi excel varaku chala questions post chestu vuntavu frequently...intaki title enti mama...deni paina work.
Oracle apps annai..contractor gaa..title gatra emi undav |
Netman
Pilla Bewarse
Username: Netman
Post Number: 212
Registered: 03-2004
Posted From: 59.93.115.116
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:50 pm: |
|
number mundu apostrophe (') add cheste aa problem povachchu |
Vkishore
Pilla Bewarse
Username: Vkishore
Post Number: 69
Registered: 10-2011
Posted From: 149.199.62.254
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:49 pm: |
|
 Out of curiosity one question mama....SQL nunchi excel varaku chala questions post chestu vuntavu frequently...intaki title enti mama...deni paina work. |
Vkishore
Pilla Bewarse
Username: Vkishore
Post Number: 68
Registered: 10-2011
Posted From: 149.199.62.254
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:47 pm: |
|
Hemu mama
Chala simple solution...CSV file ante macros enble avvavu.
6.71585E+13 is the scientific formation.Ante formatting lo scientific kinda choose chestundi cell ni....
.xls file is an excel macro enabled file. CSV is closer to almost tab delimited text file so scientific notation teesukodu..
Stewie mama cheppina solution bagane vundi...in general neeku aa problem voddu ante csv badulu other format choose chesuko mama. |
Fanno1
Yavvanam Kaatesina Bewarse
Username: Fanno1
Post Number: 6005
Registered: 03-2004
Posted From: 152.14.61.98
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:46 pm: |
|
Ravanabrahma:hesthunte aa column value 6.71585E+13 gaa sav
mama usual gaa alane vuntayi kadaa.
nee second question ardham kaaledhu. u mean nee value C67158500000000 ani vundhaa |
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 802
Registered: 03-2011
Posted From: 99.32.132.46
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:45 pm: |
|
Emuvuthund ACK etc unte.. characters kada..
motham column ni Format Cell chesi choodu .. thiduthondaa ?
Patha Signature teeseysa
|
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18156
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:44 pm: |
|
Stewie:Right click on cell, Formal Cell, change type from General to Number Katham
I think that works annai...thank you.. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18155
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:42 pm: |
|
Stewie:Right click on cell, Formal Cell, change type from General to Number Katham
ala 2000 rows data undi baa..konni cells lo C ACK etc ala untay mama number tho paatu.. |
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 800
Registered: 03-2011
Posted From: 99.32.132.46
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:41 pm: |
|
Right click on cell, Formal Cell, change type from General to Number Katham
Patha Signature teeseysa
|
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18154
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, December 09, 2011 - 5:39 pm: |
|
excel lo oka column lo value 6.71585E+13 ila untundi..kaani deeni actual value 67158500000000. nenu xls file ni .csv ga save chesthunte aa column value 6.71585E+13 gaa save avuthundi. ala avvakunda undalante emi cheyyali? |
Archives - 2011