k2s Posted February 26, 2016 Report Share Posted February 26, 2016 ok excel or CSV file import chesthunna SQL DB loki... adi truncated error vasthundi.. understood that some fields in few columns are more than allowed space limit. Found that that particular column table has extra lines ..... so need help to clean /remove those extra lines from a column. I am Beginner here. searched in internet but couldn't find what i want.. any help here ? Link to comment Share on other sites More sharing options...
badampappu Posted February 26, 2016 Report Share Posted February 26, 2016 i am not an expert but aa column trim cheyyochu anukunta Link to comment Share on other sites More sharing options...
arshad Posted February 26, 2016 Report Share Posted February 26, 2016 Link to comment Share on other sites More sharing options...
k2s Posted February 26, 2016 Author Report Share Posted February 26, 2016 i am not an expert but aa column trim cheyyochu anukunta trim cheyyochu naku telusu man.. but adey ela cheyyalo teludu trim cheyyali antey first data sql lo tables laga import avvali kada.. asalu data unstrucured format ga excel/csv file lo undi.. dani structured format ga cheyyali.. asalu aa excel file ni import chesthuntey ne truncated error 4 vasthundi .....column size entha penchina (max) ani pettina no use..same error Link to comment Share on other sites More sharing options...
k2s Posted February 26, 2016 Author Report Share Posted February 26, 2016 Link to comment Share on other sites More sharing options...
samajaaragamana Posted February 26, 2016 Report Share Posted February 26, 2016 hide cheyala column lepayala??? Link to comment Share on other sites More sharing options...
k2s Posted February 26, 2016 Author Report Share Posted February 26, 2016 hide cheyala column lepayala??? ok excel or CSV file import chesthunna SQL DB loki... adi truncated error vasthundi.. understood that some fields in few columns are more than allowed space limit. Found that that particular column table has extra lines ..... so need help to clean /remove those extra lines from a column. I am Beginner here. searched in internet but couldn't find what i want.. any help here ? column undali.. column cell lo data has more than one line.. and some cells have more than 100-200 lines.. andulo extra lines chala unnai .....avi theseyali Link to comment Share on other sites More sharing options...
badampappu Posted February 26, 2016 Report Share Posted February 26, 2016 trim cheyyochu naku telusu man.. but adey ela cheyyalo teludu trim cheyyali antey first data sql lo tables laga import avvali kada.. asalu data unstrucured format ga excel/csv file lo undi.. dani structured format ga cheyyali.. asalu aa excel file ni import chesthuntey ne truncated error 4 vasthundi .....column size entha penchina (max) ani pettina no use..same error u can trimm that colum in excel only uncle okasari check ceyyi Link to comment Share on other sites More sharing options...
RangeRover Posted February 26, 2016 Report Share Posted February 26, 2016 TRIM cheyocchu ga anni Cells @ Excel ki... https://exceljet.net/formula/remove-leading-and-trailing-spaces-from-text Link to comment Share on other sites More sharing options...
badampappu Posted February 26, 2016 Report Share Posted February 26, 2016 You can use the MID function in excel to select only the first 15 characters of your cell. MID allows you to select a substring. The syntax is =MID(data cell, starting character, length). In your case, if your text is in column A3, you would use =MID(A3,1,15) Link to comment Share on other sites More sharing options...
k2s Posted February 26, 2016 Author Report Share Posted February 26, 2016 u can trimm that colum in excel only uncle okasari check ceyyi aa excel file is more than 200MB undi man.. open ayi savatley... laptop freeze ayithundi _%~ _%~ Link to comment Share on other sites More sharing options...
badampappu Posted February 26, 2016 Report Share Posted February 26, 2016 aa excel file is more than 200MB undi man.. open ayi savatley... laptop freeze ayithundi _%~ _%~ daaniki solution teliyadu Link to comment Share on other sites More sharing options...
samajaaragamana Posted February 26, 2016 Report Share Posted February 26, 2016 TRIM cheyocchu ga anni Cells @ Excel ki... https://exceljet.net/formula/remove-leading-and-trailing-spaces-from-text You can use the MID function in excel to select only the first 15 characters of your cell. MID allows you to select a substring. The syntax is =MID(data cell, starting character, length). In your case, if your text is in column A3, you would use =MID(A3,1,15) Yes ee rendu vadachu all you will do is in excel so title excel experts ani pettu ostharu...inkonthamandi..............Sql daka avasarma ledhu Link to comment Share on other sites More sharing options...
badampappu Posted February 26, 2016 Report Share Posted February 26, 2016 Yes ee rendu vadachu all you will do is in excel so title excel experts ani pettu ostharu...inkonthamandi..............Sql daka avasarma ledhu thx Link to comment Share on other sites More sharing options...
samajaaragamana Posted February 26, 2016 Report Share Posted February 26, 2016 thx baa nee old id or original id cheppu Link to comment Share on other sites More sharing options...
.thumb.jpg.abf7d08f99d33f7507f9f0e982085cc3.jpg)
Recommended Posts