Automatic import of text file into mySQL table by phildegruchy

I am building a WordPress website for a recruitment agency. They have an internal system that exports a text file (2jobs.exm) by FTP to a location on the web server. The file contains a number of fields separated by pipes (|)… (Budget: $30-$250 USD, Jobs: Linux, MySQL, PHP)