find character in string from csv file using php?

Question

I am really a newbie in php. I have a problem in doing this..

I have sample.csv file contains 3 rows: inbound(1st row), outbound(2nd row), and date(3rd row).

sample.csv

      **inbound**                   **outbound**            **date**       
  IN/15@001234                  OUT/000000163-000000as     1/12/2014
  IN/15@004323                  NOT/000000141-00000043     1/14/2014
  IN/15@005555                  OUT/000000164-000000jk     1/15/2014

is it possible to display the all columns where 2ndrow is start with "NOT" and a number before char "-" is 141???

output:

IN/15@004323                NOT/000000141-00000043     1/14/2014

i dont know if it is possible... please help me.. I have a code below. But it only open the csv file...

$file  = fopen('Master.csv', 'r');

echo "<table style='border: 2px solid black; text-align:left'>";
while (($line = fgetcsv($file)) !== FALSE) {  
    list($inbound, $outbound, $date) = $line;          

        echo "<tr>";
        echo "<td>$inbound</td>"; 
        echo"<td>$outbound</td>"; 
        echo "<td>$date</td>";
        echo "</tr>"; 

}
echo "</table>";

is it possible to display the all columns where 2ndrow is start with "NOT" and a number before char "-" is 141???

You can convert the csv records into an array like so: stackoverflow.com/questions/7502370/converting-csv-to-array and then check if a string in the array contains a value like so: stackoverflow.com/questions/19445798/… — nomistic
– nomistic, Commented Aug 26, 2015 at 15:37

syck · Accepted Answer · 2015-08-26 15:41:21Z

1

Inserting

if (preg_match('/^NOT/', $outbound)) continue;

after the list()... statement should be sufficient.

But your data does not look like being comma-seperated, rather than tab-seperated. And perhaps you mean columns when talking about rows at the beginning?

edited Aug 26, 2015 at 15:41

answered Aug 26, 2015 at 15:37

syck

3,0391 gold badge15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bee Over a year ago

in NOT/000000141-00000043.. how to get the char before the "-" hypen?? i.e 141

syck Over a year ago

preg_match('/\\d*-/', $outbound, $matches) will give you all numbers before the hyphen in $matches[0].

syck Over a year ago

I can show you how it works. You will have to write your code yourself.

Tomasz · Accepted Answer · 2015-08-26 15:41:27Z

0

You can use strpos()

if ( strpos($outbound, 'NOT') !== false ) {
// "NOT" WORD FOUND IN STRING
}

edited Aug 26, 2015 at 15:41

answered Aug 26, 2015 at 15:37

Tomasz

5,2222 gold badges37 silver badges42 bronze badges

4 Comments

syck Over a year ago

That would yield 0 which would be treated as false.

Bee Over a year ago

in NOT/000000141-00000043.. how to get the char before the "-" hypen?? i.e 141

Tomasz Over a year ago

@Bee what do you mean?

Bee Over a year ago

I want to display Which start with NOT and the 3 char before hypen(-) is 141...... then it shows NOT/000000141-00000043

Kevin Brown-Silva · Accepted Answer · 2015-08-26 18:36:13Z

0

Try this out. This will work with comma separated csv file.

echo "<table border = 1><tr><td>first</td><td>second</td><td>third</td></tr>"; //creating table
$handle = fopen('fe.csv', "r");     //open csv file 

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)   //read csv file row by row
{
    //check both NOT and 141- in the string
    if ( (strpos($data[1], 'NOT') !== false ) && (strpos($data[1], '141-') !== false )) {
        //add required field data to table
        echo "<tr>";
        echo "<td>".$data[0]."</td>"; 
        echo"<td>".$data[1]."</td>"; 
        echo "<td>".$data[2]."</td>";
        echo "</tr>"; 
    }
}
echo "</table>"; //close table
?>

edited Aug 26, 2015 at 18:36

Kevin Brown-Silva

41.8k42 gold badges207 silver badges243 bronze badges

answered Aug 26, 2015 at 18:22

Subin Thomas

1,43610 silver badges19 bronze badges

1 Comment

Subin Thomas Over a year ago

@Bee : I think I am using the correct string comparison which you required. Update if anything else.

Collectives™ on Stack Overflow

find character in string from csv file using php?

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related