Remove comma from comma separated string

Question

I want to remove comma from string value of comma separated values.

I am parsing mysql insert queries for my project, and i am failing when string value contains comma.

I am working in php.

Example :

$temp = "INSERT INTO temp_table VALUES(1,'name','some random, address')";

as in above example, i want to remove the comma between some random and address.

Actually queries contains too many fields and complex values.

UPDATE

I hadn't mentioned my problem in depth, regrets.

I am reading from a mysql dump file, fetching insert queries in one array, then parsing each query.

preg_replace("/,(?!(?:[^']*'[^']*')*[^']*$)/", '', $var_name);

will do the work, Thanks @Avinash Raj & @MarkusQ

That means you're not actually *parsing* it. See [SQL parser in PHP?](http://stackoverflow.com/q/8970499) — mario, Sep 09 '14 at 14:08
Are you sure that the comma is the problem? The string has an issue with mis-matched quotes: `'some random, address"` — George Cummins, Sep 09 '14 at 14:09
@ErrHunter did you want to remove the commas which are present within single quotes? — Avinash Raj, Sep 09 '14 at 14:12
It is always good to use Prepared statements rather than direct sql queris. Youc an check this http://php.net/manual/en/pdo.prepared-statements.php — Thusitha Thilina Dayaratne, Sep 09 '14 at 14:13
@ThusithaThilinaDayaratne I am not using mysql, i am just parsing mysql queries. — Gaurav Gandhi, Sep 09 '14 at 14:14
@ErrHunter: If you're working with a file, will you consider non-PHP solutions also like Unix shell scripts etc? — anubhava, Sep 09 '14 at 14:23
@MarcusAdams I want to remove commas, coz in later processing i will explode the string using commas, so if comma is in string value then that will fail. — Gaurav Gandhi, Sep 09 '14 at 14:42
@AvinashRaj Solved thanks ! I did google before posting but my keywords for search was different. Post as your answer,i will accept. — Gaurav Gandhi, Sep 09 '14 at 14:50
@ErrHunter it's a duplicate question , so i marked it as duplicate.. Posting answer for a marked duplicate question is not quite right. You're always Welcome :-) — Avinash Raj, Sep 09 '14 at 14:56

mariobgr · Answer 1 · 2014-09-09T14:08:27.727

-1

First of all, you can use

 $string = str_replace(',', '', $string);

But in the example given, you are missing a closing ' before " and the query won't execute.

edited Sep 09 '14 at 14:08

answered Sep 09 '14 at 14:07

mariobgr

Then my all commas will be replaced, i jut want to remove comma between 'some random' and 'text' if referring example string. – Gaurav Gandhi Sep 09 '14 at 14:08
$string = str_replace('random,', 'random', $string); – mariobgr Sep 09 '14 at 14:09
But even better, you can use Prepared Statements to prevent this. – mariobgr Sep 09 '14 at 14:11
please at least consider my regex, it does actually match only the comma you want to replace. maybe a new export would be better, but sometimes a regex does the job too. – pauel Sep 09 '14 at 14:22

pauel · Answer 2 · 2014-09-09T15:07:03.083

-2

If you have problems in your sql and there is no way of exporting again you could use a regular expression to improve the replacing.

$regex = '/(,)(?!\'.*\))/';

I suggest something like preg_replace($regex, '', "INSERT INTO temp_table VALUES(1,'name','some random, address')");

edited Sep 09 '14 at 15:07

answered Sep 09 '14 at 14:09

pauel

ahh not so stupid my regex :-) – pauel Sep 09 '14 at 14:24
+1 for trying regex, but your regex doesnt work. – Gaurav Gandhi Sep 09 '14 at 14:49
then try (,)(?!\'.*\)), shit stackoverflow removes some of the regex – pauel Sep 09 '14 at 15:05
here is a online tool to create and test http://www.regexr.com/. There are many of those out there and hey; regex always help :-) – pauel Sep 09 '14 at 15:09
Thnks bud for help ! – Gaurav Gandhi Sep 09 '14 at 15:11
What I would do is convert the comma-separated string into an array and use array_walk function to remove the comma in every elements. Finally, convert back the modified array into an string – jvicab Sep 09 '14 at 15:34