Find the string

JohnBampton · August 28th, 2009, 06:56 AM

Thank you Mike.

I knew it was a regex problem

Regards,

John.

ITEpicurean · August 28th, 2009, 11:03 AM

Michael,

I am sorry to say that your suggest regex expression gives the following error:

>> [Saxon-B 9.1.0.7] The regular expression in replace() must not be one that matches a zero-length string

samjudson · August 28th, 2009, 11:08 AM

Change one of the '*' for a '+', e.g.:

replace($in, '.*?(aaabbcc.{3,7}dddeeefff.{2,4}xxxyyyzzz)+(.*)', '$2')

You will also need to make sure you have the correct number of 'x', 'y' and 'z's because you original examples do not work (two x's in the string, three in the pattern).

mhkay · August 28th, 2009, 11:10 AM

>I am sorry to say that your suggest regex expression

Then fix it.

If you find code from me in an answer, it's not intended as a working solution, it's there to suggest a way forward.

ITEpicurean · August 28th, 2009, 11:17 AM

Sam,

Thank you for both insights.

Michael,

Thank you for the suggestion on the way forward (I an new to this sight and was unaware of the conventions).