Hi Julien, d2rq:valueRegex is just a performance optimization. It specifies a regex that matches the *entire* value. It cannot be used to extract a sub-string from the value.
It also expects a Java-style regular expression, not a Perl-style regular expression. The former don't need to be the enclosing two identical characters. You probably want to look into d2rq:sqlExpression for solving your task. (Or fix that database schema! ;-) Best, Richard On 2 Apr 2011, at 17:16, <[email protected]> <[email protected]> wrote: > Hi, > > I have a problem to extract parts of a string. I explain that I have this > type of string in one of the following fields in my database: > > a:4:{i:0;s:129:"28 espace Coralium Route nationale 1 Kawéni, BP 424 97600 > Mamoudzou Téléphone : 02 69 61 18 71 Télécopie : 02 69 61 18 72 ";i:1;s:44:"1 > carrefour de la Liberté 97600 Mamoudzou ";i:2;s:64:"Assemblée nationale 126 > rue de l'Université 75355 Paris 07 SP ";i:3;s:0:"";} > > And I'd like to extract the two parties which are: > > 28 espace Coralium Route nationale 1 Kawéni, BP 424 97600 Mamoudzou > > and > > 1 carrefour de la Liberté 97600 Mamoudzou > > and > > Assemblée nationale 126 rue de l'Université 75355 Paris 07 SP > > But that's not all, I would like for each of the parties that I created a > property value "v: workAdr". So in this case I should have to see under D2R > two occurrences of this property. If I have two parties that are extracted so > I should have two occurences of this property and so on. > > To do so I use "d2rq: valueRegex" with the regular expression: > > #”(.*?)”# > > But I get an error when launching the server because of my regex. > > Any idea how to solve this problem? > > Best. > > Julien. > ------------------------------------------------------------------------------ > Create and publish websites with WebMatrix > Use the most popular FREE web apps or write code yourself; > WebMatrix provides all the features you need to develop and > publish your website. http://p.sf.net/sfu/ms-webmatrix-sf > _______________________________________________ > d2rq-map-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ d2rq-map-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
