Search Results

Thanks to everybody for the suggestions - the file is now imported :)

Ross

Thanks for the quick reply jostber and suggesting sed - however I think I did not make my problem clear enough - the lines of the textfile can contain any text, i.e.

H1234 Widget type A ...

Hi

I have a text file which is position delimited, i.e.

Code1 Description1 Value1
Code2 Description2 Value2 etc.

I want to import this file into MySQL so I want to convert...