I had to do something similar - try this:
let $string := "Peña, replaces dia char"
return replace($string, '[^\p{L}|\p{N}]+', '')
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Rajasekaran,
Santhosh
Sent: 11 May 2012 13:08
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Need to Remove spaces, punctuations,
parens and ect., from the given string (need to remove all character other than
A-Z and 0-9)
Hi Jakob,
Thanks, Ya it worked well, but it also removes the diacritics character also.
If i do not want to remove diacritics the what to do?
Eg: -->
let $string := "Peña, replaces dia char"
return replace($string, '[^a-zA-Z]+', '')
==> Peareplacesdiachar
I need "Peñareplacesdiachar"
Thanks
Santhosh
________________________________________
From: [email protected]
[[email protected]] On Behalf Of Jakob Fix
[[email protected]]
Sent: Thursday, May 10, 2012 10:22 AM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Need to Remove spaces, punctuations,
parens and ect., from the given string (need to remove all character other than
A-Z and 0-9)
Hi,
it's probably easier if you declare the character groups you want to
keep and excluding everything else, like so:
let $string := "AB cd/EF;gh"
return replace($string, '[^a-zA-Z]+', '') (: everything that's not an
alphabetical character will be replaced :)
==> "ABcdEFgh"
cheers,
Jakob.
On Thu, May 10, 2012 at 4:00 PM, Rajasekaran, Santhosh
<[email protected]> wrote:
> Hi Folks,
>
>
>
> I have the below requirement in Xquery.
>
>
>
> Given a string I need to remove spaces, punctuation, parens and etc.,
> (I.e)except alpha(A-Z or a-z) and numeric 0-9
>
>
>
> Eg:
>
>
>
> Input Expected Output
>
>
>
> San & co., Sanco
>
> It is a string Itisastring
>
> New (value) Newvalue
>
> At,the hill + school Atthehillschool
>
> Oh!.. is it, I don't know OhisitIdontknow
>
>
>
> Please let me know how do I achieve this. Do I need to add all this
> characters (spaces,punctuation,parens and etc., in regular expression and
> replace that one by one) using fn:replace() function.
>
> Or
>
> Do we have any other better suggestion?
>
>
>
> Thanks & Regards,
>
> Santhosh
>
>
> _______________________________________________
> General mailing list
> [email protected]
> http://developer.marklogic.com/mailman/listinfo/general
>
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general