Datafeed Parser

[svh1]

Hello,

 

I need to build a parser that dumps the data into a MySQL database and I'm hoping someone out there will be kind enough to guide me through this.  My data comes to me via a .txt format and is pipe delimited.  Here's a snippet of the data:

 

|58196|0206|Lube & tire work. F/T. Bilingual a plus. Apply at Elliott Tire |40008295|

|57719|0206|Heavy Equipment Mechanic  needed North end. (123)555-5555|40020937|

 

The really tricky thing is that I need the first and last columns to be removed completely.  I also need the second column (the 0206) to be converted to a name based on the number.  In this example the 0206 would be renamed to 'Mechanical'.

 

Any help would be GREATLY appreciated!

[trq]

Just use explode to turn each line into an array.

[svh1]

I was hoping for some sample code to at least get me going.  Yeah, I know, "stupid n00bs!" but hey, this is a help forum, right?

[trq]

This should give you the idea.

 

<?php

    $s = "|58196|0206|Lube & tire work. F/T. Bilingual a plus. Apply at Elliott Tire |40008295|";
    $a = explode('|',$s);
    foreach ($a as $v) {
        echo $v."\n";
    }  

?>