PHP String Edit - Simple

Question

I am creating a website that pulls data from a CSV file and then displays the album artwork that matches the album and artist however I've hit a snag... the file presents artists as either a band (example: U2) or the artist (Dylan, Bob) the later does not work with the api.

I've tried to no success to edit the string so if it sees "," it will then rearrange the artist from last, first to first last

Does anyone know a solution to this?

Cheers!

rubs crystal ball line 12, character 5 needs to be upper case! In seriousness though, we'll need to see your code before we can give any real help. — jprofitt
– jprofitt, Commented Nov 28, 2011 at 14:16
Do you mean you can't rearrange the string, or it still doesn't work after you have rearranged it? — DaveRandom
– DaveRandom, Commented Nov 28, 2011 at 14:16
You need to provide more information. Is the CSV file correct or do the additional , result in a problem? You mentioned an API...do you mean PHP or are you using some library? — Till Helge
– Till Helge, Commented Nov 28, 2011 at 14:17
I hope your CSV is quoting special characters or you'll never get it to work — nachito
– nachito, Commented Nov 28, 2011 at 14:18

Michael Berkowski · Accepted Answer · 2011-11-28 14:22:36Z

2

explode() on , (comma-space) into variables $last, $first. If $first is nonempty, rearrange them. Otherwise, just output the original $fullname.

$fullname = "Dylan, Bob";

$parts = explode(", ", $fullname);
$first = isset($parts[1]) ? $parts[1] : NULL;
$last = $parts[0];
if (!empty($first)) {
  $output = "$first $last";
}
else $output = $fullname;

edited Nov 28, 2011 at 14:22

answered Nov 28, 2011 at 14:16

Michael Berkowski

271k47 gold badges451 silver badges395 bronze badges

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

3 Comments

DaveRandom Over a year ago

$first will always be populated because (annoyingly) list() populates from right to left. So you would need to do if ($last). I think.

Michael Berkowski Over a year ago

@DaveRandom Yes, looks to be so. I made some changes accordingly.

Keiran Lovett Over a year ago

This seems to be the best one so far! Thanks for your help!

SERPRO · Accepted Answer · 2011-11-28 14:17:50Z

1

A regex might work for you:

if( preg_match("#(\w+),\s?(\w+)#", $artist) )
    $artist = preg_replace("#(\w+),\s?(\w+)#", "\2 \1", $artist)

answered Nov 28, 2011 at 14:17

SERPRO

10.1k8 gold badges49 silver badges64 bronze badges

Comments

Marc B · Accepted Answer · 2011-11-28 14:17:52Z

1

$string = "Dylan, Bob";
$fixed = preg_replace('/^(.*), (.*)$/', '$2 $1' , $string);

answered Nov 28, 2011 at 14:17

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

PHP String Edit - Simple

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related