title: How to search only lines with certain length in text file
body: <p>I have a large delimited txt file with two columns and about 17 million lines. I have imported it to the database, mistakenly one column in table had shorter size than the text from the file. i.e. varchar (4000) instead of varchar (7000)</p>
  
  <p>about 48 thousands records with longer text has been cut into 40k chars.</p>
  
  <p>How would I replace these without re-importing the files again? </p>
  
  <p>I am thinking if I could be able to filter from txt file only lines with certain length, and remove them, and try to insert update the longer lines.</p>
  
  <p>But How do I select all lines with certain length in a text file? or which program can do that.</p>
  
  <p>I am using MySQL DB and emEditor for large files text editing.</p>
  
  <p>Thanks.</p>