replace text without using regex

mrame · July 25th, 2008, 10:12 AM

In there any way to replace text without using regex.

Input: M19999991999999
Ootput: ,

any help is appreciated

mhkay · July 25th, 2008, 03:12 PM

>In there any way to replace text without using regex.

Yes, for example you can use translate() or you can use combinations of concat(), substring() substring-before(), etc.

>Input: M19999991999999
>Ootput: ,

That's a bit like saying

>Input: What is the meaning of life?
>Output: 42

and expecting someone to come up with an algorithm.

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

Old Pedant · July 25th, 2008, 03:52 PM

>Input: What is the meaning of life?
>Output: 42

Algorithm: Add the fourth smallest prime number to itself one more times than the value of that same number.

(Well, you didn't ask for a *correct* algorithm. <grin/>)

mrame · July 25th, 2008, 04:50 PM

Thank you.

Can anyone help me to get the regex to find
1,[ and ]1,

mhkay · July 25th, 2008, 05:12 PM

Try

1,\[

\]1,

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

mrame · July 25th, 2008, 05:22 PM

Mike, its not working.
I want to find ]1, and replace it with ],

1 can be any number.

thanks

mhkay · July 25th, 2008, 06:44 PM

If you want to match any number, then say so, don't say you want to match "1". You really need to learn to express your requirements more clearly, until you learn to phrase your questions correctly you will never get useful answers.

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

mrame · July 28th, 2008, 09:12 AM

I should thank you for teaching these things. Sorry for that Mike.