Removing excess comma in PHP output string

Question

I want to remove the excess comma in my output string inside a parenthesis.

 $data= "item_id IN ( '1','2',) AND nt_id IN ( 'er1','er2',) AND";

I removed the Excess 'AND' by using rtrim funtion.

$trimValues = rtrim($data,'AND') ;

But how can I remove the comma inside a parenthesis?

vks · Accepted Answer · 2017-02-23 04:35:34Z

1

,(?=\s*\))

You can use this and replace by empty string.See demo.

https://regex101.com/r/rkDV4X/1

$re = '/,(?=\s*\))/';
$str = 'item_id IN ( \'1\',\'2\',) AND nt_id IN ( \'er1\',\'er2\',) AND';
$subst = '';

$result = preg_replace($re, $subst, $str);

echo "The result of the substitution is ".$result;

answered Feb 23, 2017 at 4:35

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Removing excess comma in PHP output string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related