Hey All I have been given a .txt file with 2.5 million rows. Each row has a number of different information such as date etc. Is there any way to extract just the date (first 10 characters on each row) and so i can import it into my database? Hope someone can help ! Alex
Personally, I would use something like navicat (http://www.navicat.com/) to import the text file into the db. Assuming that there is some sort of delimitation, you can select which data to import and what table / column to import in into. They offer a free persona version and a free 30 day trial of their commercial version. SOunds like this should do exactly what you need without having to strip down the text in the file.
What is your database, mysql or mssql ? Is the txt well formed ? You must give indication before we can give any advices.
will try that link now jestep thanks justinlorder - the text file is well formed, first 7 charchers are what i need and the 16-21 and 30-34 on every line. Database is mysql