Programming

hello,

I'm writing a php script in fedora to run with a csv file. I want the script to read column 4 and multiply each single line in the column by 1000, how would that script look? I've written one script but it's obviously incorrect because it will not execute the command.

here is my script

Code:

<?php

$fileName_$SERVER["argv"][1];
echo "file: $filename\n";
$fp = fopen("$filename","r")or exit("cannot open or read file\n");

while(!feof($fp)). "\n";
    {
     echo fgets($fp). "\n";
     }
     fclose($fp);
      {

//This is where the problem comes in below

awk -F  '(($4=$4*1000); print $4\t)';
        }

Thanks,
Brandon

Welcome to the forums. I've moved your post to the programming forum where it's more appropriate(PHP is not shell programming) and will see more attention. In the future please post new questions as new threads.

PHP is not shell, you cannot run awk there in that way. You could run it with popen() and feed data into it, but I'm not entirely sure what you're trying to feed into it yet, so it's difficult to illustrate how.

Is this script being run through CGI, or locally? I'm not sure what I'm looking at. It's very odd to see $SERVER being used at the same time as ARGV arguments, since CGI generally doesn't have commandline arguments at all, just stdin and env variables...

This is local, I'm trying to run this via the command line. The csv file i've written looks similar to this...

Tom, Jack, seats, 45, 115
Donna, Tom, seats, 55,56
ect..

The initial php script gave me the output that I wanted. What I'm wanting to do is have the script read the fourth column and multiply each line by 1000 and have it display on the command line. Would make it wayyy easier than going in and changing the original code, since there are about 500 or so lines. oh, and i'm trying to make them tab delimited files so I can get that space between each line, that is the reason behind the '\t'

Using awk here would be quite awkward. (Pardon the pun.) It would be much better to either

1) convert this inside PHP itself

Code:

while($str=fgets($fp))
{
        $arr=explode(",", $str);
        $arr[3]=sprintf("%d", intval($arr[3])*1000);
        print implode("\t", $arr), "\n";
}

or

2) use awk externally, as part of a pipe chain.

Code:

php myprogram.php filename | awk -F, -v OFS="\t" '{ $4 *= 1000 } 1'

ya that works out much better than I was doing..

..thanks alot for your help, I'm definitely happy with the outcome.

~Brandon