replace with string between pattern

Question

I have a question. I want to read a wrong xml format with the php function simplexml_load_string but I get empty values because the format is worng. Part of the xml:

<column name="price"><![CDATA[184.95]]></column>
<column name="category"><![CDATA[Dames]]></column>
<column name="subcategory"><![CDATA[Schoenen]]></column>
<column name="stock"><![CDATA[1]]></column>

I need to replace it to this:

<price><![CDATA[184.95]]></price>
<category><![CDATA[Dames]]></category>
<subcategory><![CDATA[Schoenen]]></subcategory>
<stock><![CDATA[1]]></stock>

to read the xml feed properly. Is it possible to replace this with preg_match for example? And how?

XSLT was defined for exactly that - converting one XML into another. — ThW
– ThW, Commented Sep 5, 2014 at 16:47
You do not necessarily get empty values only because of that XML. It looks fine. You probably don't know how to access it? Just commenting not that you ask the wrong way around and that you solve a programming problem in a way that works diametral against what you want to achieve (like using a regex in your accepted answer). Could it be? — hakre
– hakre, Commented Sep 8, 2014 at 12:20

Toto · Accepted Answer · 2014-09-05 11:45:47Z

1

How about:

$str = preg_replace('#<column name="([^"]+)">(.+?)</column>#', '<$1>$2</$1>', $str);

edited Sep 5, 2014 at 11:45

answered Sep 5, 2014 at 11:14

Toto

91.7k63 gold badges97 silver badges135 bronze badges

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

1 Comment

Bo Pennings Over a year ago

hi m42, this should be the solution but it isn't working. Even when i use regex tester regexpal.com it doesn't highlight the strings..

Community · Accepted Answer · 2017-05-23 10:33:37Z

0

The below would do it, but I think you could probably do it with preg_replace, see this link: php preg_replace matches

preg_match_all('/<column name=\"([a-z]+)\">(.*)<\/column>/', $string, $matches);

$string = '';
foreach( $matches[1] as $key => $name )
{
    $string .= "<{$name}>{$matches[2][$key]}</{$name}>\n";
}

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Sep 5, 2014 at 10:54

Ryan

1,3382 gold badges10 silver badges18 bronze badges

Collectives™ on Stack Overflow

replace with string between pattern

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related