Jump to content

@@@@calling All Datastage Developers@@@@

qwerty1204

By qwerty1204
in Old Discussions

 Share

Recommended Posts

kalyann Hero

kalyann

Posted
Posted

[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]

Link to comment
Share on other sites
  • Replies 2.3k
  • Created
  • Last Reply

Top Posters In This Topic

  • pandemkodi

    410

  • Silver_mani

    401

  • qwerty1204

    381

  • mrudhula99

    212

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

D.V.S.KARNA
D.V.S.KARNA

babulu..smilys & gifs veyyakandi saami....yee thread ayina plane ga discussion la undanivandi

qwerty1204
qwerty1204

[quote name='pandemkodi' timestamp='1329871354' post='1301438316'] yup got it baa error tables levu nenu run chestunna env lo choosta error tables create chesi choostaaa anyways thanks baa

Silver_mani
Silver_mani

ee thread ni [b]DSXchange[/b] range ki teeskoni povali mama manam [img]http://lh3.ggpht.com/-l3hAEE6GX1Q/T26USh0uf9I/AAAAAAAAGP8/6W_pgNGh9bQ/s300/k.gif[/img]

mrudhula99 Celebrity

mrudhula99

Posted
Posted

[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....

Link to comment
Share on other sites
Nisacharudu Sr. Hero

Nisacharudu

Posted
Posted

[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?

Link to comment
Share on other sites
dalapathi LEGEND

dalapathi

Posted
Posted

[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

Link to comment
Share on other sites
Nisacharudu Sr. Hero

Nisacharudu

Posted
Posted

[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

Link to comment
Share on other sites
lolliman Celebrity

lolliman

Posted
Posted

[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

Link to comment
Share on other sites
lolliman Celebrity

lolliman

Posted
Posted

[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.

Link to comment
Share on other sites
qwerty1204 Sr. Hero

qwerty1204

Posted
  • Author
Posted

[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 :15_3_321:

expands the column length in your excel file (drag to the righttttttttttttttttt)

Link to comment
Share on other sites
mrudhula99 Celebrity

mrudhula99

Posted
Posted

[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

Link to comment
Share on other sites
mrudhula99 Celebrity

mrudhula99

Posted
Posted

[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

Link to comment
Share on other sites
tom bhayya VIP

tom bhayya

Posted
Posted

[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

Link to comment
Share on other sites
mrudhula99 Celebrity

mrudhula99

Posted
Posted

[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...

Link to comment
Share on other sites
lolliman Celebrity

lolliman

Posted
Posted

[quote name='mrudhula99' timestamp='1357861620' post='1303088264']

its not gonna work... datastage lo nee edho cheyyali...
[/quote]



adi kaadu ide choodehee ^G#W ^G#W :3D_Smiles_314:


[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]

Link to comment
Share on other sites
lolliman Celebrity

lolliman

Posted
Posted

[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... ^G#W ^G#W

pina inko post esaaa choodu

Link to comment
Share on other sites
mrudhula99 Celebrity

mrudhula99

Posted
Posted

[quote name='lolliman' timestamp='1357863271' post='1303088376']

text pad lo correct vundi, excel lo correct raavatle antunnav gaaa... datastage lo em chesthav... ^G#W ^G#W

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...

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...