Cut off leading information

ChetUbetcha

I have a string that's generated that I'm trying to import into MySQL. How do I take a line that has:

Number, Page, Section, Reviewer, Remark

which can be:

1, 2, 3, reviewer_name, remark_text

and trim everything before the first comma and the comma itself, then trim the reviewer_name and comma so I end up with:

2, 3, remark_text

I have been searching through str_ commands, replace commands, etc. and just can't find what I need.

Thanks!

PS I do not want to use arrays for this unless absolutely necessary.

ChetUbetcha

Should I locate the positions of the commas and cut out the text preceding those commas and the comma itself? I've been looking at strrpos and strpos, but I'd love it if someone could lend a hand. I've been looking at this thing for too long.

laserlight

You could use [man]explode/man and [man]implode/man.

ChetUbetcha

Also, what happens if someone inserts a comma into the table cell? Won't that throw off everything?

ChetUbetcha

Should I dump everything into an array and then omit the array positions 0 and 3? (that would be Number and Reviewer in my example) Of course, how do I do THAT?

laserlight

Also, what happens if someone inserts a comma into the table cell? Won't that throw off everything?

Yes, but then it shows that you have a problematic format to begin with. Is this normal CSV format (i.e., the fields are quoted as needed), or really only what you have described?

Should I dump everything into an array and then omit the array positions 0 and 3? (that would be Number and Reviewer in my example) Of course, how do I do THAT?

It sounds like you are asking questions and ignoring the suggested answers.

NogDog

$text = '1, 2, 3, reviewer_name, remark_text';
list($number, $page, $section, $reviewer, $remark) = preg_split('/\s*,\s*/', $text);
echo "$page, $section, $remark";

PS: This does not address the additional commas issue, as it was not part of the originally stated requirement when I was typing it up.