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 because of ...

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 only ...

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, which ...

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 engine ...

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

It was a pleasure to help you Ben.

Cheers

Meisn