Xls problem   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2007Cine Talk - Reviews, Gossips, Insider Info etc.Archive through September 05, 2007 � Xls problem Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Panileni
Pilla Bewarse
Username: Panileni

Post Number: 17
Registered: 03-2006
Posted From: 65.121.89.6

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 5:26 pm:Edit PostDelete PostView Post/Check IP

use dos2unix or unix2dos command
Top of pagePrevious messageNext messageBottom of pageLink to this message

Sinna
Celebrity Bewarse
Username: Sinna

Post Number: 18514
Registered: 04-2005
Posted From: 74.136.203.203

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:58 pm:Edit PostDelete PostView Post/Check IP

ascii lo chesthe radu adi Binary lo chesthe vasthundi last lo ctrl M character unix lo idoka gola
Thagalapettestha... Lanka Dahanam... Na Vaddaku Rakandi...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4209
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:46 pm:Edit PostDelete PostView Post/Check IP

yeh vere ftp tool lo raledu. winscp lo vachindi. ascii pedithe radaa. thanks mama.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pedarayudu
Pilla Bewarse
Username: Pedarayudu

Post Number: 497
Registered: 04-2007
Posted From: 129.138.18.85

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:32 pm:Edit PostDelete PostView Post/Check IP

//vasutundi general ga ,


annai malli tappav..
neeku indaka esina sicha lo one week ni one months sesko
Top of pagePrevious messageNext messageBottom of pageLink to this message

Edo_okati
Celebrity Bewarse
Username: Edo_okati

Post Number: 8335
Registered: 03-2007
Posted From: 72.192.211.214

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:19 pm:Edit PostDelete PostView Post/Check IP

ftp chesetappudu vasutundi general ga ,

asci ftp chest potundi
naaku single chukkettinodu kanchara gaadidallo nikrusttmina kanchara gaadida
Top of pagePrevious messageNext messageBottom of pageLink to this message

Srinu15
Kurra Bewarse
Username: Srinu15

Post Number: 2184
Registered: 08-2005
Posted From: 98.197.141.242

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:13 pm:Edit PostDelete PostView Post/Check IP

oh..textpad lo replace feature kooda undaa..aithe inka enduku discussaanu..
You never know what you can do, Until you try
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 16057
Registered: 04-2005
Posted From: 71.70.173.154

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:08 pm:Edit PostDelete PostView Post/Check IP

ammani pills ga , idedo bhale ga unde

ee paaali eppudaanna avsaram ayyinappudu vaadeddam

srinu15 mama naaku aa boxer sangathi telvadu
naaku single esinavaadu kanchara gaadida
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4208
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:07 pm:Edit PostDelete PostView Post/Check IP

avuna. adedo sootha ee sari srinu mama.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Srinu15
Kurra Bewarse
Username: Srinu15

Post Number: 2183
Registered: 08-2005
Posted From: 98.197.141.242

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:04 pm:Edit PostDelete PostView Post/Check IP

yeah ala cheyyachu emo Kalki mama..
I mean windows lo command issue chesi aithe cheyyalemu emo..

nuvvu annatu aithe inko method undi, csv file ni Boxer ane text editor lo open chesi..andulo column wise lines ni select chesukovacchu, ala select chesukoni delete cheyyadame aa chars ni..

Boxer ane text editor lo manchi features untaai..
You never know what you can do, Until you try
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4207
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:03 pm:Edit PostDelete PostView Post/Check IP

windows lo ayithe picha easy ga mama.

textpad lo open chesi replace kotti ^M painaichi kinda emi ivvakapothe replace chesi dobbidhi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4206
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 4:02 pm:Edit PostDelete PostView Post/Check IP

sorry command :%s/^M//g
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 16055
Registered: 04-2005
Posted From: 71.70.173.154

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:56 pm:Edit PostDelete PostView Post/Check IP

one step lo seyyalem emo srinu15 mama

import data into XLS then select 'fixed width , cit ^M off , then again copy paste in to a text file and then import data withput that comma

ala sesi malla text file lo copy seste vastadi

saala sollu poxx process ee
naaku single esinavaadu kanchara gaadida
Top of pagePrevious messageNext messageBottom of pageLink to this message

Srinu15
Kurra Bewarse
Username: Srinu15

Post Number: 2182
Registered: 08-2005
Posted From: 98.197.141.242

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:53 pm:Edit PostDelete PostView Post/Check IP

idi windows lo ela chestaaru..
You never know what you can do, Until you try
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 16054
Registered: 04-2005
Posted From: 71.70.173.154

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:49 pm:Edit PostDelete PostView Post/Check IP

hehehe
naaku single esinavaadu kanchara gaadida
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4205
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:49 pm:Edit PostDelete PostView Post/Check IP

1 koda kavali mama. vaadu cheppinattu :%s^M//g anna vi lo open chesi. ^M vasthaniki aa command lo CTRL V and M kottali. kiki. bhale undi. ^M ni replace chesindi with empty tho.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4204
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:48 pm:Edit PostDelete PostView Post/Check IP

chesaaa. work ayyindi aa link lo seppinattu sethe
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kalki
Bewarse Legend
Username: Kalki

Post Number: 16053
Registered: 04-2005
Posted From: 71.70.173.154

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:47 pm:Edit PostDelete PostView Post/Check IP

8M1012900,1^M

pills ga neeku emi kaavali indulo????


8M1012900 -->idi vaste chaala??? lekapothe ,1 kooda raavalaa??
naaku single esinavaadu kanchara gaadida
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4203
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:44 pm:Edit PostDelete PostView Post/Check IP

vaarni vi lo ipen chesi chosthe ^M undi csv file lo. ippudu ela replace cheyyali. vadedo % command annadu kani ela ivvalo ardam kavatam ledu :-(
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4202
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:42 pm:Edit PostDelete PostView Post/Check IP

http://math.la.asu.edu/support/doc/editvi.html

ikkadedo dorikindi. kiki soothunna.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 4201
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, August 31, 2007 - 3:35 pm:Edit PostDelete PostView Post/Check IP

8M1012900,1^M
8S7501170,1^M
864793010,1^M
841925900,8^M
864776000,4^M
8J3162002,1^M
877600330,1^M
8K3910000,12^M
8C9909900,1^M
8A5021002,3^M
8K0910000,7^M
8Q9145000,2^M
884911000,1^M
866217900,1^M
8Q1067500,1^M
8T3435170,1^M
8Q9923900,13^M
8Q1065100,2^M
8Q5310900,2^M
866345000,3^M
8M0912000,1^M
8M0812000,5^M
8Q1013000,1^M

akkada ^M enduku vasthundi. actual ga nenu xls file ni .csv ga marchanu. csv lo mamulugane undi. kaani table loki load chesthunte invalid number antundi 2nd column. .bad file lo paina unnattu undi. aa ^M ekkada nunchi vasthundi :-( ela thiyyali danni.