Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 [WTA] How to find and extra number, Either using Excel or other method

views
     
zimorok
post Mar 2 2019, 11:07 AM

Getting Started
**
Junior Member
170 posts

Joined: Nov 2012
Using PHP and number with hyphen treated as range
CODE
<?php
       //Enter your code here, enjoy!

$a1 = ['1','3','6-8','10-21','23','25-30'];
$a2 =[];

foreach($a1 as $d)
{

   if(strpos($d,"-") !== false)
   {
       //have dash, make range of number
       $e = explode("-", $d);
       $a2 =array_merge($a2,range($e[0], $e[1]));
   }
   else
   {
       $a2[] = $d;
   }

}
$c = range(1,50);
print_r(array_diff($c, $a2));


--p/s: sorry, necro old post 😂😂
mentalhealth.my
post Mar 3 2019, 05:15 AM

Getting Started
**
Validating
147 posts

Joined: Sep 2015
---------------------------------

This post has been edited by mentalhealth.my: Mar 10 2019, 08:57 PM

 

Change to:
| Lo-Fi Version
0.0140sec    0.55    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 10:26 PM