preg_replace end replace

[Ginji]

PHPBuilder,
This is the code I use:

			$parameter = explode(",", $lines[$i], 20);
			$format = $parameter;
			$tmp = explode("},{", $parameter[19]);
			// Replacements
			$replace[0] = "";
			$replace[1] = "";
			$pattern[0] = "/{/";
			$pattern[1] = "/},/";

		$patternx[0] = "/,{/";
		$patternx[1] = "/},/";

		$patterns[0] = "/,{/";
		$patterns[1] = "/}";
		$format[19] = trim(preg_replace($pattern, $replace, $tmp[0],1));
		$format[20] = trim(preg_replace($patternx, $replace, $tmp[1],1));
		$format[21] = trim(preg_replace($patterns, $replace, $tmp[2],1));

What I want to know is how do I check for the last } in a text?
For instant, I wanna replace ,{Hi, {Name}},{How's {Job} {Time}},{You Doing {Name}} to remove the { } for the beginning and end of it so it'll be:
,Hi, {Name},How's {Job} {Time},You Doing {Name}

Regards.

[NogDog]

$newString = preg_replace('/\{(.*)\}/', '\\1', $string);

[Ginji]

PHPBuilder,
I tried that but it didn't work.

	for ($i = 0; $i < count($lines); $i++) {
		if (!preg_match("/^\/\//",$lines[$i])) {
			$parameter = explode(",", $lines[$i], 20);
			$format = $parameter;
			$tmp = explode("},{", $parameter[19]);
			$format[19] = trim(preg_replace('/\{(.*)\}/', '\\1', $tmp[0]));
			$format[20] = trim(preg_replace('/\{(.*)\}/', '\\1', $tmp[1]));
			$format[21] = trim(preg_replace('/\{(.*)\}/', '\\1', $tmp[2]));

I used this to convert:
1,Test,Test,,,,,,,,,,,,,,,,,{ Testing },{},{}

But it dispalyed:
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{ TEST',NULL,'}'

Regards.

[halojoy]

hi

{xx{Name}xx}, aaa {yyy{Job}{Time}} => xx{Name}xx, aaa yyy{Job}{Time}

{xx{Name}xx}, {yy{Time}yy} => xx{Name}xx, yy{Time}yy

Nog Dog's code only removes first and last bracket
I tried to solve this.
But I managed to remove ALL of the brackets.

The closest I came, was one variant that did replace all with the last match:
{aa{Name}}, {bbb{Name}} => bbb{Name}

[Ginji]

I don't get it, what I'm looking for is that it removes the ,{ + ,} + }(Nothing else here)

Such that
1,Test,Test,,,,,,,,,,,,,,,,,{ Testing },{},{}

will become
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,' TEST ',NULL,NULL

And
1,Test,Test,,,,,,,,,,,,,,,,,{ Testing {} Test { } },{ test{}},{finaltest{} again{}}
will become:
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,' Testing {} Test { }','test{}','finaltest{} again{}'

[NogDog]

$search = array(
   '/\},|,\{/' => ',',
   '/\}$/' => '',
   '/,,/' => ',NULL,'
);
$string = preg_replace(array_keys($search), $search, $string);

[halojoy]

this is how I got it
and what i have tried to do:

{Hi, {Name}}, {How's {Job} {Time}}, {You Doing {Name}}
should be:
Hi, {Name}, How's {Job} {Time}, You Doing {Name}

in other words, you want to take away the outer level of brackets
in the way that each substring
{Hi, {Name}}
becomes
Hi, {Name}

Did I get you wrong?

[Ginji]

$search = array(
   '/\},|,\{/' => ',',
   '/\}$/' => '',
   '/,,/' => ',NULL,'
);
$string = preg_replace(array_keys($search), $search, $string); 

I tried that, but it didn't work. It randomly kept some { and }. There's more to the code; it changes ,, to NULL somewhere in the script as well.
@
Yes.
As a addition, I'm trying to replace more than 1 line of string.

By extending the script a bit, I got it to:

			$replace[0] = "";
			$replace[1] = "";
			$patternx[0] = "/{/";
			$patternx[1] = "/},/";
			$patterny[0] = "/,{/";
			$patterny[1] = "/},/";
			$patternz[0] = "/,{/";
			$patternz[1] = "/\}$/";
			$format[19] = trim(preg_replace($patternx, $replace, $tmp[0],1));
			$format[20] = trim(preg_replace($patterny, $replace, $tmp[1],1));
			$format[21] = trim(preg_replace($patternz, $replace, $tmp[2]));

But the patternz doesn't seem to work if I try to replace more than one line of string.

Using this:

1,Test,Test,,,,,,,,,,,,,,,,,{ Testing {} Test { } { } { } }{{ } },{ test{} finaltest{ } {{}{ }{ }{}{} again{} },{finaltest{ } {{}{ }{ }{}{} again{}}
1,Test,Test,,,,,,,,,,,,,,,,,{ Testing {} Test { } { } { } }{{ } },{ test{} finaltest{ } {{}{ }{ }{}{} again{} },{finaltest{ } {{}{ }{ }{}{} again{}}

I got:

'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}}'
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}'

The first one has a extra }.

[Ginji]

I'm not sure if double-posting after a few days is allowed, but: Can anyone answer this for me?

[halojoy]

Hi Ginji

you have shown:
1. Using this string
2. I got this
... is there some info missing? Yes, isnt it.
3. Was expecting this

The better info we give, the better chance to quicker and better help

🙂 🙂
This is basic information to all problems/questions topics.
If trying to get an advice or assistance
1. What I did, a good description
2. What I got, including all details
3. What I want to get and had expected
🙂 🙂

Regards

[Ginji]

What do you mean by "What I did"?

To answer two and three:
2. What I got: (No idea how to explain it any further than this)

'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}}'
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}'

3. What I expected:

'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}'
'1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}'

What's the difference? Well, scroll to the right and you'll notice there's a extra }.

[halojoy]

1. what is your initial teststring

maybe you have posted it some posts ago?
And I have missed it.
🙂

What I mean,
we do an action and want an outcome.
We get an unexpected outcome.
When outcome is not right we want to fix this.
These are 3 things we need to know
in order to have a fair chance to fix any problem.

If you have submitted all information and I have missed it:
sorry.

Regards 🙂

[Ginji]

I'm pretty sure I did post it. Lemme just simplify it; I'm trying to convert certain strings to a SQL REPLACE INTO entry.

So I using the full script, I place this in a textarea:

1,Test,Test,,,,,,,,,,,,,,,,,{ Testing {} Test { } { } { } }{{ } },{ test{} finaltest{ } {{}{ }{ }{}{} again{} },{finaltest{ } {{}{ }{ }{}{} again{}}
1,Test,Test,,,,,,,,,,,,,,,,,{ Testing {} Test { } { } { } }{{ } },{ test{} finaltest{ } {{}{ }{ }{}{} again{} },{finaltest{ } {{}{ }{ }{}{} again{}}

Nothing too unusual there. I was expecting the outcome to remove the ,{ and }, AND the last } at the end of each line; or replace them with ' at least.
Which should supply this SQL query:

REPLACE INTO file VALUES ('1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}');
REPLACE INTO file VALUES ('1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}');

But instead, I received:

REPLACE INTO file VALUES ('1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}}'); <----- It didn't remove the last } at the end of the string.
REPLACE INTO file VALUES ('1','Test','Test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Testing {} Test { } { } { } }{{ }','test{} finaltest{ } {{}{ }{ }{}{} again{}','finaltest{  {{}{ }{ }{}{} again{}');

To add to it, the first } in the last ,{ } brace is removed; another problem. Meaning:
finaltest{ } {{}{ }{ }{}{} again{}
became:
finaltest{ {{}{ }{ }{}{} again{}} and finaltest{ {{}{ }{ }{}{} again{}

[Ginji]

Any help?

[Ginji]

Is anybody able to answer this?