Geek Answers Handbook

Php - line cropping

Please help me with this.

$str = "col_1          col_2  col_3
row1 row2 row3
row12 row22        row33";

$arr = explode("\n", $str);

foreach($arr as $line)
{
   $temp_arr = explode(WHAT HERE, $line); 
}

How to explode every row in an array? I want to $temp_arr[0] = col_1, $temp_arr[1] = col2, $temp_arr[2] = col_3 the next line will be $temp_arr[0] = row1,$temp_arr[1] = row2

You guys are awesome. It works on my example, but it does not work on my real problem. I export Windows XP processes and want to blow them up.

Caption CommandLine ProcessId  
System Idle Process 0          
System 4          
smss.exe \ SystemRoot \ System32 \ smss.exe 604        
avgrsx.exe C: \ PROGRA ~ 1 \ AVG \ AVG10 \ avgrsx.exe / restart / boot 692        
csrss.exe C: \ WINDOWS \ system32 \ csrss.exe ObjectDirectory = \ Windows SharedSection = 1024,3072,512 Windows = On SubSystemType = Windows ServerDll = basesrv, 1 ServerDll = winsrv: UserServerDllInitialization, 3 ServerDll = winsrv: ConServerDllInitrol = Off MaxRequestThreads = 16,780        
winlogon.exe winlogon.exe 820        
services.exe C: \ WINDOWS \ system32 \ services.exe 880        
lsass.exe C: \ WINDOWS \ system32 \ lsass.exe 892        
nvsvc32.exe C: \ WINDOWS \ system32 \ nvsvc32.exe 1052       
svchost.exe C: \ WINDOWS \ system32 \ svchost -k DcomLaunch 1168       
svchost.exe C: \ WINDOWS \ system32 \ svchost -k rpcss 1240       
svchost.exe C: \ WINDOWS \ System32 \ svchost.exe -k netsvcs 1328       
svchost.exe C: \ WINDOWS \ system32 \ svchost.exe -k NetworkService 1404       
svchost.exe C: \ WINDOWS \ system32 \ svchost.exe -k LocalService 1520       
spoolsv.exe C: \ WINDOWS \ system32 \ spoolsv.exe 1664       
explorer.exe C: \ WINDOWS \ Explorer.EXE 1956       
jqs.exe "C: \ Program Files \ Java \ jre6 \ bin \ jqs.exe" -service -config "C: \ Program Files \ Java \ jre6 \ lib \ deploy \ jqs \ jqs.conf" 460        
avgtray.exe "C: \ Program Files \ AVG \ AVG10 \ avgtray.exe" 1156       
rundll32.exe "C: \ WINDOWS \ system32 \ RUNDLL32.EXE" C: \ WINDOWS \ system32 \ NvMcTray.dll, NvTaskbarInit 1204       
alg.exe C: \ WINDOWS \ System32 \ alg.exe 1376       
AVGIDSMonitor.exe "C: \ Program Files \ AVG \ AVG10 \ Identity Protection \ agent \ bin \ avgidsmonitor.exe" 660        
iexplore.exe "C: \ Program Files \ Internet Explorer \ iexplore.exe" 620        
OUTLOOK.EXE "C: \ Program Files \ Microsoft Office \ Office12 \ OUTLOOK.EXE" / recycle 1884       
SQLyog.exe "C: \ Program Files \ SQLyog \ SQLyog.exe" 2596       
UniKeyNT.exe "C: \ Program Files \ unikey40RC2-1101-win32 \ UniKeyNT.exe" 964        
avgcsrvx.exe C: \ Program Files \ AVG \ AVG10 \ avgcsrvx.exe / pipeName = 4f758821-d931-4842-ae08-b81fe89b843a / coreSdkOptions = 0 / binaryPath = "C: \ Program Files \ AVG \ AVG10 \" / registryPath = "SYSTEM \ CurrentControlSet \ Services \ Avg \ Avg10" 3788       
svchost.exe C: \ WINDOWS \ system32 \ svchost.exe -k imgsvc 3604       
mstsc.exe "C: \ WINDOWS \ system32 \ mstsc.exe" 3868       
notepad ++. exe "C: \ Program Files \ Notepad ++ \ notepad ++. exe" 4072       
notepad.exe "C: \ WINDOWS \ system32 \ NOTEPAD.EXE" C: \ Documents and Settings \ Quy Nguyen \ Desktop \ cool.txt 2228       
cmd.exe "C: \ WINDOWS \ system32 \ cmd.exe" 2552       
wmic.exe WMIC /OUTPUT:C:\ProcessList.txt PROCESS get Caption, Commandline, Processid 2480       
wmiprvse.exe C: \ WINDOWS \ system32 \ wbem \ wmiprvse.exe 1744
+5
source share
4 answers

replace

$temp_arr = explode(WHAT HERE, $line);

with

$temp_arr = preg_split('/\s+/', $line, -1, PREG_SPLIT_NO_EMPTY);

Edit: added PREG_SPLIT_NO_EMPTY

OK, so your question has changed a bit. This code should do exactly what you want:

$processes = 'the list you posted';

$temp = preg_split('/\s*(?:\r?\n)+/', $processes, -1, PREG_SPLIT_NO_EMPTY);
$process_list = array();
foreach ($temp as $process) {
    $process_list[] = array_pad( // array_pad makes the length consistent
        preg_split(
            '/\s{2,}/', // match only 2 or more consecutive spaces for splitting
            $process,
            3,
            PREG_SPLIT_NO_EMPTY), // ignore empty matches (i.e., end of line)
        3, // pad array to a length of 3
        ''
    );
}

$process_list_final = array();
$process_list_titles = array_shift($process_list);

foreach ($process_list as &$plist_item) {
    $plist_item = array_combine($process_list_titles, $plist_item);
}

It may take a little cleaning, but you can do it yourself =)

Some features to search for:

+3
source

You probably want to preg_split.

$str = "col_1          col_2  col_3
    row1 row2 row3
    row12 row22        row33";

$arr = explode("\n", $str);

foreach($arr as $line)
{
   $temp_arr = preg_split("#\s+#", $line, -1, PREG_SPLIT_NO_EMPTY); 
}

preg_split, explode, -, , . :

  • # " "
  • \s+ " ".
  • -1 , ( , )
  • PREG_SPLIT_NO_EMPTY - , , , :

        row1

. "#\s++#", 2 , + . .

+2
$temp_arr = explode("\n", $line);
0

PHP - php.

, , , , :

foreach ($arr as $line) {
  // removing double-spaces
  while(strpos($line, ' ') !== false) $line = str_replace('  ', ' ', $line);
  // trim leading and trailing spaces. you can safely move it to explode
  $line = trim($line);
  // will be better if you replace double-spaces before. it will be faster a lot.
  //-> just space character (0x20) here now (!)
  $temp_arr = explode(' ', $line);
}

You can also immediately split the array into variables with list. Similar:

list( $row1, $row2, $lastrow ) = explode(" ", $line);`

Do not use preg_split for this simple problem. Too slow for that.

Good luck)

0
source

More articles:


All Articles