kalyann Posted January 10, 2013 Report Posted January 10, 2013 [quote name='Nisacharudu' timestamp='1357854908' post='1303087468'] danni excel lo open seyaku [b]notepad[/b] lo open chey [/quote] [img]http://i28.tinypic.com/ipcent.gif[/img]
mrudhula99 Posted January 10, 2013 Report Posted January 10, 2013 [quote name='dalapathi' timestamp='1357854992' post='1303087480'] idhi generla gaa csv files excel format lo open chestey aah column length saripoka atlaa short chesi chuupistadhi kadaa ... aah column tab ni extend chesi chuustey full kanipistadhi ... adhi correct aey load ayyindhi anukuntaa ... nuvvu chuudatma atlaa chuustunnav kaavochu ... aah column ni extend chesi chuudu okasaari total mottham kanipinchelaagaa [/quote] thappu data load avuthundhii... notepad lo correct ee undhii... same file ni excel lo open cehsthee elaa + ani showing....
Nisacharudu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='mrudhula99' timestamp='1357854997' post='1303087484'] noo naku excel lo nee kavali.... i need to send that file to someone. [/quote] first notepad lo ope seste neku kavalisina format lo unda leda?
dalapathi Posted January 10, 2013 Report Posted January 10, 2013 [quote name='mrudhula99' timestamp='1357855090' post='1303087498'] thappu data load avuthundhii... notepad lo correct ee undhii... same file ni excel lo open cehsthee elaa + ani showing.... [/quote] Hmmmmmmmm ... etlaa cheppali neeku Data correct aey load ayyindhi ... excel lo nuvvu aah column pakkana cursor peditey ... daani drag chesey option vastadhi ... drag cheyyi danainin total column motthama nni characters kanipinchetattu
Nisacharudu Posted January 10, 2013 Report Posted January 10, 2013 [quote name='dalapathi' timestamp='1357854992' post='1303087480'] idhi generla gaa csv files excel format lo open chestey aah column length saripoka atlaa short chesi chuupistadhi kadaa ... aah column tab ni extend chesi chuustey full kanipistadhi ... adhi correct aey load ayyindhi anukuntaa ... nuvvu chuudatma atlaa chuustunnav kaavochu ... aah column ni extend chesi chuudu okasaari total mottham kanipinchelaagaa [/quote] agreed
lolliman Posted January 10, 2013 Report Posted January 10, 2013 [quote name='dalapathi' timestamp='1357855183' post='1303087510'] Hmmmmmmmm ... etlaa cheppali neeku Data correct aey load ayyindhi ... excel lo nuvvu aah column pakkana cursor peditey ... daani drag chesey option vastadhi ... drag cheyyi danainin total column motthama nni characters kanipinchetattu [/quote] select all cells (ctrl A), click [b]wrap text [/b]button
lolliman Posted January 10, 2013 Report Posted January 10, 2013 [quote name='mrudhula99' timestamp='1357854758' post='1303087451'] help... help.. output data ni oka .csv file lo ki rasthuntee... 4.45004E+15 ani vasthunhdiii windows lo open chesinapudu... kani naku... 4450040995414227 format lo kavali... help [/quote] If you ever enter a very large number into a cell, you'll notice that Microsoft Excel displays it in scientific notation. For example, when you enter the number 1231231231234 in a cell, Excels displays 1.23123E+12. No matter how large you make the cell width, Excel still displays a number larger then 12 characters in scientific notation. To display the number in a format other than scientific notation, you need to reformat the cell(s). Here's how:[list] [*]Select the cells that will hold the larger values and right-click the selection. [*]Select Format Cells. [*]In the Number tab, select the desired format (e.g., Number) and click OK. [/list] Now when you enter the values that have more than 12 characters they will be formatted as numbers and not scientific notation.
qwerty1204 Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='mrudhula99' timestamp='1357855090' post='1303087498'] thappu data load avuthundhii... notepad lo correct ee undhii... same file ni excel lo open cehsthee elaa + ani showing.... [/quote] akkada dala bhayya..aritipandu thokka valichi mari chepthe neeku malli..thokkaloo doubts nuvvu nuuu expands the column length in your excel file (drag to the righttttttttttttttttt)
mrudhula99 Posted January 10, 2013 Report Posted January 10, 2013 [quote name='dalapathi' timestamp='1357855183' post='1303087510'] Hmmmmmmmm ... etlaa cheppali neeku Data correct aey load ayyindhi ... excel lo nuvvu aah column pakkana cursor peditey ... daani drag chesey option vastadhi ... drag cheyyi danainin total column motthama nni characters kanipinchetattu [/quote] nuvve chepthunavoo ardham ayyendhii naku.. nenu csv file lo ki data load chessaa.. unix loo suppose 12345 undhanukoo... same record nenu unix ki theskochinapudu 12340 avuthundhiiii
mrudhula99 Posted January 10, 2013 Report Posted January 10, 2013 [quote name='Nisacharudu' timestamp='1357855105' post='1303087502'] first notepad lo ope seste neku kavalisina format lo unda leda? [/quote] notepad lo data correct vasthundhiiii.... excel ki copy chestheee vere gaa vasthundhiii aa 16digit number maripothundhiiiii istam vachinatlu
tom bhayya Posted January 10, 2013 Report Posted January 10, 2013 [quote name='mrudhula99' timestamp='1357861492' post='1303088255'] notepad lo data correct vasthundhiiii.... excel ki copy chestheee vere gaa vasthundhiii aa 16digit number maripothundhiiiii istam vachinatlu [/quote] paina lolliman post chudu
mrudhula99 Posted January 10, 2013 Report Posted January 10, 2013 [quote name='lolliman' timestamp='1357856647' post='1303087736'] select all cells (ctrl A), click [b]wrap text [/b]button [/quote] its not gonna work... datastage lo nee edho cheyyali...
lolliman Posted January 11, 2013 Report Posted January 11, 2013 [quote name='mrudhula99' timestamp='1357861620' post='1303088264'] its not gonna work... datastage lo nee edho cheyyali... [/quote] adi kaadu ide choodehee [quote name='lolliman' timestamp='1357857578' post='1303087826'] If you ever enter a very large number into a cell, you'll notice that Microsoft Excel displays it in scientific notation. For example, when you enter the number 1231231231234 in a cell, Excels displays 1.23123E+12. No matter how large you make the cell width, Excel still displays a number larger then 12 characters in scientific notation. To display the number in a format other than scientific notation, you need to reformat the cell(s). Here's how:[list] [*]Select the cells that will hold the larger values and right-click the selection. [*]Select Format Cells. [*]In the Number tab, select the desired format (e.g., Number) and click OK. [/list] Now when you enter the values that have more than 12 characters they will be formatted as numbers and not scientific notation. [/quote]
lolliman Posted January 11, 2013 Report Posted January 11, 2013 [quote name='mrudhula99' timestamp='1357861620' post='1303088264'] its not gonna work... datastage lo nee edho cheyyali... [/quote] text pad lo correct vundi, excel lo correct raavatle antunnav gaaa... datastage lo em chesthav... pina inko post esaaa choodu
mrudhula99 Posted January 11, 2013 Report Posted January 11, 2013 [quote name='lolliman' timestamp='1357863271' post='1303088376'] text pad lo correct vundi, excel lo correct raavatle antunnav gaaa... datastage lo em chesthav... pina inko post esaaa choodu [/quote] what ever... nenu manual gaa chesesaa le.. inka repu submit cheyali.. akkada nuvvu cheppindhi work avvaledhu.. data thanaki istam vachinatlu vasthundhii...
Recommended Posts