How to parse fixed width column text in php?

by

First of all, there was sscanf:

$vars = sscanf($string, '%s %s %d %s');

It is optimized for whitespace separated values, and you can specify the variable type already (%s = string; %d = integer)(; even name the variables but that is not demonstrated in the example).

Example/Demo:

$lines = explode("\r\n", $input);

foreach($lines as &$line)
{
    $line = sscanf($line, '%s %s %d %s');
}

var_dump($lines);

Output:

array(6) {
  [0]=>
  array(4) {
    [0]=>
    string(8) "DB2INST1"
    [1]=>
    string(14) "db2jcc_applica"
    [2]=>
    int(11446)
    [3]=>
    string(29) "10.0.0.209.51406.120606004531"
  }
  [1]=>
  array(4) {
    [0]=>
    string(8) "DB2INST1"
    [1]=>
    string(14) "db2jcc_applica"
    [2]=>
    int(11448)
    [3]=>
    string(29) "10.0.0.209.51407.120606004536"
  }
  [2]=>
  array(4) {
    [0]=>
    string(8) "DB2INST1"
    [1]=>
    string(14) "db2jcc_applica"
    [2]=>
    int(13762)
    [3]=>
    string(29) "10.0.0.206.57473.120606024909"
  }
  [3]=>
  array(4) {
    [0]=>
    string(5) "ADMIN"
    [1]=>
    string(14) "db2jcc_applica"
    [2]=>
    int(15220)
    [3]=>
    string(29) "10.0.0.210.52248.120606045402"
  }
  [4]=>
  array(4) {
    [0]=>
    string(8) "DB2INST1"
    [1]=>
    string(8) "php-fpm:"
    [2]=>
    NULL
    [3]=>
    NULL
  }
  [5]=>
  &array(4) {
    [0]=>
    string(8) "DB2INST1"
    [1]=>
    string(14) "db2jcc_applica"
    [2]=>
    int(16547)
    [3]=>
    string(29) "10.0.0.202.52042.120606065813"
  }
}

More Related Contents:

  1. I keep getting these kind of errors in terms of HttpUrlConnection and BackGroundTask in android
  2. PHP parse/syntax errors; and how to solve them
  3. Best XML Parser for PHP [duplicate]
  4. How to evaluate formula passed as string in PHP?
  5. How to use XMLReader in PHP?
  6. parse youtube video id using preg_match [duplicate]
  7. Is there a PDF parser for PHP? [closed]
  8. Transform relative path into absolute URL using PHP
  9. Parse HTML with PHP’s HTML DOMDocument
  10. Manually parse raw multipart/form-data data with PHP
  11. How exactly is a PHP script executed?
  12. How to parse HTML in PHP?
  13. Parse a CSS file with PHP
  14. PHP CSV string to array
  15. preg_match(); – Unknown modifier ‘+’ [duplicate]
  16. How to solve JSON_ERROR_UTF8 error in php json_decode?
  17. Fastest way to retrieve a in PHP
  18. Preg match text in php between html tags
  19. Get parts of URL in PHP
  20. Parsing URL query in PHP [duplicate]
  21. Simplify PHP DOM XML parsing – how?
  22. PHP: Best way to extract text within parenthesis?
  23. PHP – parse current URL
  24. What is a good parser generator for php?
  25. json parse error with double quotes
  26. How do I get the value from object(stdClass)?
  27. PHP DOMDocument getting Attribute of Tag
  28. What RSS parser should I use in PHP?
  29. PHP Version 5.2.14 / Parse error: syntax error, unexpected T_FUNCTION, expecting ‘)’
  30. Code to parse user agent string?

Leave a Comment