I want to remove the ',' dellimiter between " " in php

Question

I want to remove the ',' dellimiter between " " only . Exmp : "Alibris: Books, Music, & Movies"

Output of 1st row should be

256,2653,"Alibris: Books  Music  & Movies",50263394,05/14/2013,07:44,50263394,114.85,1,5.74,05/14/2013,08:10

example of array here

Array
(
    [0] => 256,2653,"Alibris: Books, Music, & Movies",50263394,05/14/2013,07:44,50263394,114.85,1,5.74,05/14/2013,08:10,
    [1] => 256,2653,"Alibris: Books, Music, & Movies",50327805,05/21/2013,23:03,50327805,-6.99,1,-0.35,05/22/2013,07:10,
    [2] => 256,2653,"Alibris: Books, Music, & Movies",50327805,05/21/2013,23:03,50327805,6.99,1,0.35,05/22/2013,00:10,
    [3] => 527,36777,BuySKU,920130525042340263061,05/24/2013,20:25,1390043,"1,170.73",11,58.54,05/24/2013,20:55,
)

You need to show your code and explain why it isn't doing what you want. — Barmar, Jul 02 '13 at 04:45
I want to split the row in array based on delimeter , but not into "" — Manoj Rathore, Jul 02 '13 at 04:48
I hope you're not doing this simply as a way to be lazy when parsing CSV files. If you are, think about using [`str_getcsv`](http://www.php.net/str_getcsv) or [`fgetcsv`](http://www.php.net/fgetcsv) instead. — icktoofay, Jul 02 '13 at 04:50

score 2 · Answer 1 · answered Jul 02 '13 at 04:53

Here's the approach I suggest you take:

For each line in the file
- Read the line into an array using PHP's CSV functions (http://php.net/manual/en/function.fgetcsv.php)
- Modify the element of the array that you want to modify using, probably, str_replace.
- Write out the array in CSV format (http://www.php.net/manual/en/function.fputcsv.php)

The key is that you need to get the string broken up into its component parts, rather than trying to modify certain commas but not others.

Anirudha · Accepted Answer · 2013-07-02T05:07:59.447

1

You can do it this way

,(?!([^"]*"[^"]*"[^"]*)+$|[^"]*$)

replace it with empty string

This would match , only if there are odd number of " ahead.So it would match , if its between "

DEMO

So,it would be

$pattern = "/,(?!([^\"]*\"[^\"]*\"[^\"]*)+$|[^\"]*$)/"; 
$replace = ""; 
$line = preg_replace($pattern,$replace,$line);

If you want to split it with , only its outside " use

 ,(?=([^"]*"[^"]*"[^"]*)+$|[^"]*$)

So it would be

preg_split('/,(?=([^\"]*\"[^\"]*\"[^\"]*)+$|[^\"]*$)/', $text);

edited Jul 02 '13 at 05:07

answered Jul 02 '13 at 04:44

Anirudha

32,393
7
68
89

If he uses that pattern with `preg_replace`, what should the replacement be to get rid of the commas? – Barmar Jul 02 '13 at 04:46
@Barmar oops..edited the ans and a demo – Anirudha Jul 02 '13 at 04:47
I want to split the row in array based on delimeter , but not into "" – Manoj Rathore Jul 02 '13 at 04:48
@intekhabkhan you want to split or replace..be clear with your question – Anirudha Jul 02 '13 at 04:56
@Barmar can you pass me code .. of this – Manoj Rathore Jul 02 '13 at 04:59
@intekhabkhan check out the edit at end – Anirudha Jul 02 '13 at 05:02
@Anirudh I want to split the row in array. I m using { ,} delimeter but " " create problem beacuse of have {,} in "" – Manoj Rathore Jul 02 '13 at 05:02
@intekhabkhan you can use `/,(?=([^\"]*\"[^\"]*\"[^\"]*)+$|[^\"]*$)/` to split – Anirudha Jul 02 '13 at 05:04

score 0 · Answer 3 · edited May 23 '17 at 12:11

0

You can use str_getcsv and a str_replace in a closure to accomplish this

$rec = str_getcsv($line);
$rec = array_map(
     function($x){
          return str_replace(",", "", $x); 
     },$rec);

Now you end up with an array that you can use in a call to fputcsv

If you absolutely need the value as a string you can use a the str_putcsv implementation inplemented here.

Note that this syntax (inline closures as well as the str_getcsv function) will only work in php 5.3+

edited May 23 '17 at 12:11

Community

1
1

answered Jul 02 '13 at 04:55

Orangepill

24,500
3
42
63

Not working I m using this code :: foreach ($wrong_row as $khy => $vae) { $vae = str_replace(",","",$vae); } – Manoj Rathore Jul 02 '13 at 04:57
@intekhabkhan That is because within the foreach $vae is passed by value instead of by reference so editing the value does nothing to the original array. – Orangepill Jul 02 '13 at 05:02

I want to remove the ',' dellimiter between " " in php

3 Answers3