Extract one value from a single multi-value row in an array

Question

Possible Duplicate:
In PHP, is there a function that returns an array made up of the value of a key from an array of associative arrays?

Several values stored in one single row in an array like this:

Array
(
  [data] =>
     Duration: 1 Month
     Name: James Foo
     Category: Info Tech
)

Question:

How could I extract and echo the values from [data] separately? i.e. display only Category: Info Tech?

If all above is a value of element at index `data`, then how rows fo data are separated? Is there a space between them like `Duration: 1 Month Name: James Foo Category: Info Tech` or is there a new line after each like `Duration: 1 Month\nName: James Foo\nCategory: Info Tech`. After getting this info you will receive an answer. — Eugene, Dec 29 '12 at 01:49

kittycat · Accepted Answer · 2012-12-29T04:07:46.603

1

If you prefer regex you can do this:

$array = array('data' =>
'Duration: 1 Month
Name: James Foo
Category: Info Tech');

function get_line($array, $line)
{
    preg_match('/' . preg_quote($line) . ': ([^\n]+)/', $array['data'], $match);
    return $match[1];
}

echo get_line($array, 'Category');

edited Dec 29 '12 at 04:07

answered Dec 29 '12 at 01:37

kittycat

14,983
9
55
80

Thanks a bunch for this. How do you omit the 'category:' label and just echo the 'Info Tech'? Also, I would like to point out that the values inside [data] are in a list (
).
– xchampionx Dec 29 '12 at 01:51
@xchampionx can you update your question with the raw text of print_r(), I think you copied and pasted from screen reason the HTML was not copied as well. I can easily modify my solution if I knew the correct format it is in. – kittycat Dec 29 '12 at 02:10
@xchampionx, I'm heading out to eat dinner, but if I am correct on your format if you change the `\n` to `<` it should work. If not, I'll check back and modify solution based on your question update. – kittycat Dec 29 '12 at 02:21
1

Thank you so much @cryptic. Worked wonders. The regex is specially useful as I can just switch between 'Duration', 'Name' and 'Category' easily. Not quite the case for the first two. The above solutions also worked with the
tag. So no problem here I thought it would be just worth mentioning.

xchampionx

Dec 29 '12 at 03:52

score 0 · Answer 2 · edited Dec 29 '12 at 01:44

0

foreach ($array as $k => $v)
    echo "Category: ".$v['Category']."\n";

edited Dec 29 '12 at 01:44

Musa

96,336
17
118
137

answered Dec 29 '12 at 01:22

King Skippus

3,801
1
24
24

I don't think the $v is an array but a large string. You would need to parse the string and extract that line. – kittycat Dec 29 '12 at 01:23

Extract one value from a single multi-value row in an array

Question:

2 Answers2