Parsing a delimited text file into mysql database

**ronverdonk** · Apr 7 '08, 09:09 AM

Originally posted by s4ndr0ck

Would someone be kind enough to write a php file which will do that?
Because i know nothing about this parsing things, and just a very little knowledge about php. So the code would need to be complete i hope..

At this forum we do not provide complete code by request!

This is a site where experts and programmers help other programmers with the code they have developed themselves or with problems they encounter while developing code.

For a complete php script you'll have to turn to a paid php programmer, not to this forum.

Ronald

**s4ndr0ck** · Apr 17 '08, 03:21 PM

I'm sorry...

I have this line from a text file:

Code:

Cpu(s):(B[m[39;49m(B[m 1.4%(B[m[39;49mus,(B[m[39;49m(B[m 1.6%(B[m[39;49msy,(B[m[39;49m(B[m 0.0%(B[m[39;49mni,(B[m[39;49m(B[m 96.3%(B[m[39;49mid,(B[m[39;49m(B[m 0.4%(B[m[39;49mwa,(B[m[39;49m(B[m 0.3%(B[m[39;49mhi,(B[m[39;49m(B[m 0.1%(B[m[39;49msi,(B[m[39;49m(B[m 0.0%(B[m[39;49mst(B[m[39;49m[K

and i have made a code to search this line and put into an array, the code is like this :

[PHP]
<?
$lines = file('cpu050420 081937.txt');

$teams = array();

foreach($lines as $line){
if(preg_match('/Cpu\.\S$/',$line)){
$teams[] = $line;
}
}
?> [/PHP]
I need to find a line started with Cpu(s).

But it always return an empty array. Could somebody please help me to make it work??

**ronverdonk** · Apr 17 '08, 05:47 PM

Using == will work quicker, as in[php]foreach($lines as $line){
if (substr($line, 0, 3) == 'Cpu')
$teams[] = $line;
}[/php]Ronald

**s4ndr0ck** · Apr 18 '08, 02:19 AM

please correct me if i'm wrong,
[PHP]<? substr($line,0, 3) == Cpu ?>[/PHP]
is to read $line from 1st character to 3rd character, and compare it to string 'Cpu'

It works, thank you...

Parsing a delimited text file into mysql database

Parsing a delimited text file into mysql database

Comment

Comment

Comment

Comment