[SOLVED] Rearranging txt

[newbtophp]

I have a large txt which looks like this:

 

         7  blah...blahrandomtext                                       ~7      ~, '%7C'
         4  blah...blahrandomtext                                       ~7      ~7, 'html'
         5  blah...blahrandomtext                                       ~7      ~7, '+'
         6  blah...blahrandomtext                                       ~7      ~7, 'xmlns'
         7  blah...blahrandomtext                                       ~7      ~7, '%7D'
         8  blah...blahrandomtext                                       ~7      ~7, '%22'
         9  blah...blahrandomtext                                       ~7      ~7, 'http'
        10  blah...blahrandomtext                                       ~7      ~7, '%7A%2F%2F'
        11  blah...blahrandomtext                                       ~7      ~7, 'www'
        12  blah...blahrandomtext                                       ~7      ~7, '.'
        17  blah...blahrandomtext                                       ~7      ~7, 'w7'
        14  blah...blahrandomtext                                       ~7      ~7, '.'
        15  blah...blahrandomtext                                       ~7      ~7, 'org'
        16  blah...blahrandomtext                                       ~7      ~7, '%2F'
        17  blah...blahrandomtext                                       ~7      ~7, '1999'
        18  blah...blahrandomtext                                       ~7      ~7, '%2F'
        19  blah...blahrandomtext                                       ~7      ~7, 'xhtml'
        20  blah...blahrandomtext                                       ~7      ~7, '%22'

etc.

 

 

I want to rearrange it using php tolook like this:

 

 

%Chtml+xmlns%7D%22http%7A%2F%2Fwww etc.

 

To remove everything except the stuff within the single quotes and join them?

 

All help is greatly apreciated 

[ashton321]

Not sure, but you may want to look into ltrim()

[MadTechie]

Not sure, but you may want to look into ltrim()

That would be quite a trim..

you could get the string position of the first and last quote and use substring to pull it out,

 

but should work (Untested)

<?php
$lines = file('theFile.txt');
$data = "";
foreach ($lines as $line) {
    if (preg_match('/\'([^\']*)\'/', $line, $regs)) {
    	$data .= $regs[1];
    }
}
echo $data;

[ashton321]

Yeah it would be but im not all that great and it would be where i would start.  Your way looks a lot better.

[newbtophp]

Thanks madtechie that worked

[salathe]

If it is a really large file, you won't be wanting to load it all into memory at once. How large is "large"?

[MadTechie]

Very true, if this is a one off then your be okay but for less memory usage try

<?php
$handle = fopen("theFile.txt", "r");
if ($handle) {
    $data = "";
    while (!feof($handle)) {
        $line = fgets($handle, 4096);
        if (preg_match('/\'([^\']*)\'/', $line, $regs)) {
            $data .= $regs[1];
        }
    }
    fclose($handle);
    echo $data;
}

[thebadbad]

If the syntax is strictly as in your sample (i.e. with no single quotes in the random text), you could also use a single preg_match_all() call:

 

<?php
$source = file_get_contents('filename.txt');
preg_match_all('~\'([^\']+)\'~', $source, $matches);
$data = implode('', $matches[1]);
?>

[MadTechie]

That approach only works by loading everything into memory..

as salathe stated it could be a very large file, also this has been solved !