PHP String parsing into multiple parts

Question

I have more than 2 lac records in DB like this: [u'jazz', u' female vocalists', u' vocal jazz', u' jazz vocal'] I need to parse out each record via PHP.

for example,

$tags="[u'jazz', u' female vocalists', u' vocal jazz', u' jazz vocal']";

I need to parse out 4 individual little tags, as:

jazz
femal vocalists
vocal jazz
jazz vocal

What is a "lac record"? How did you get $tags? Is that from a single database column? — Mike
– Mike, Commented Mar 14, 2014 at 4:30
is the u'jazz', a typo/cut and paste failure or does every entry start with u ? — Scuzzy
– Scuzzy, Commented Mar 14, 2014 at 4:30
Looks like a Python list of unicode strings. A simple regex would do instead of parsing. — mario
– mario, Commented Mar 14, 2014 at 4:32
@GOOG Then you have a design problem. You should store your tags in a separate table instead of some sort of string of text like that. This will save you many headaches down the road. — Mike
– Mike, Commented Mar 15, 2014 at 0:49

Community · Accepted Answer · 2023-11-17 19:55:19Z

2

Use preg_match_all

<?php
$tag="[u'jazz', u' female vocalists', u' vocal jazz', u' jazz vocal']";
preg_match_all("~'(?:\s?([^']+))'~",$tag,$matches);
print_r($matches[1]);

OUTPUT

Array
(
    [0] => jazz
    [1] => female vocalists
    [2] => vocal jazz
    [3] => jazz vocal
)

edited Nov 17, 2023 at 19:55

CommunityBot

11 silver badge

answered Mar 14, 2014 at 4:34

Nambi

12k4 gold badges40 silver badges50 bronze badges

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

1 Comment

GOOG Over a year ago

suppose I have like this [u'sweden', u' black', u" rock'n'roll", u' hellacopters'] I need to parse out 4 individual little tags, as: 1. sweden 2. black 3. rock n roll 4. hellacopters

Collectives™ on Stack Overflow

PHP String parsing into multiple parts

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related