Community

Many many many thanks Ben!!!

I will try this as soon as possible.

I hope that I can help you with anything else.

Yor are the best Ben!

Regards,

Meisn

Hi,

Thank you Ben for the simplification of the expression.

BTW,
(?!<column-ref name="(B2|LCX|etc)_SK"/>)(<column-ref name="[^"]*)_SK"/>
can be simplified to
(<column-ref name="(?!B2|LCX|etc)[^"]*)_SK"/>


My knowledge in scripts is very very basic. I had thought about learning perl (mostly ...

Hello,

I have to do some changes in a xml. I have to add column-referneces to certain tables with column-refernces ending with _SK .

The file looks like this (i have marked the columns in bold):

<table name="RA_F_B2_XV" skip-update="false">
<column-ref name="B2_SK"/>
<column-ref name="QRRFLG ...

^[^-]?[^-]+?$

It should match only uncommented lines.

Cheers

Meisn

Hi,

could you please try this one. It will also ignore any whitespaces.

^[^-[:space:]]+.*$

Regards

Meisn

Hi,

I can't understand what you're really looking for.
You wrote that you want to find lines which doesn't begin with '--' (which could be comments) - actually you wrote that you want to ignore them.

If you're using my suggested regex on the following SQL (in example)

^[^-]+.*$

you will find ...

Hello Thomas,

I've tried to find something out and this solution works with the WildEdit:

(.) ON (?!\1)[A-Z]+

It uses the Negative Lookahead to prevent the regex from matching equal characters and catch the character afterwards.

This is:

1. (.) any charcter
2. (?!\1) the negative lookaround ...

Hi,

sorry Thomas but there was a slightly misunderstanding when I had posted my first answer.

My suggestion will only find preceding or equal matches like A ON A etc.

Your question was to find the opposite which is more difficult to do.

I will try to think about it and will post my results (if I ...

Hi,

If you want to search for a line which doesn't begins with a certain character use the negatived class followed after the a line anchor.

In your example this could look like the following:

^[^-]+.*$

(Using POSIX-Syntax)

Hope this could help you.

Regards,

Meisn

Hi Thomas,

have you tried the same procedure with wild edit?

(.) ON \1

will work with it.

The thing is, if I understand this correctly, that the POSIX Syntax (or NFAs in general) doesn't support back-references in the search string. Maybe this is related to the backtracking mechanism of the ...

ben_josephs wrote: Apologies for any confusion caused, and thanks, Ronny.

It was a pleasure to help you Ben.

Cheers

Meisn