Community

I wanted to do a search and replace of all visible characters (Space thru Tilde), except for Comma and Quote, and replace it with a lowercase x. I tried to use this, but I missed some things. [x20-x21x23-x2Bx2D-x7E] Then I tried this, which also missed some things. ([x20-x21]|[x23-x2B]|[x2D-x7E]) Sh...

ben_josephs wrote:The ordering isn't quite right. Try
^.{5}(?!.*get )(?:[^*].*)?\*isn

A great many thanks!

Use a negative lookahead : ^.{5}((?:[^*](?!.*get +).*)?\*isn) I was thinking it should be negative lookbehind, but I haven't used them enough to really master them. Getting hits on these strings using your RE. 2580 GET RFRL-V *ISN(LABEL_3.) 1210 GET UPD-CLAIM *ISN (RD-CLM.) 1600 GET CLAIM *ISN (098...

AmigoJack wrote:

kengrubb wrote:I'm working in Natural, as in Software AG Natural.

Not sure why you say that, but I thought this board always relates to TextPad (and its regular expression abilities).

I should have been clearer. I'm using Textpad to search and view Natural code.

I've been puzzling over how to make this happen, and I just know there's someone way smarter than me with Regex who can make this happen. I want to do a Regex Search to find this: ^.{5}([^*].*\*isn|\*isn) But not find this: ^.{5}([^*].*get +.*\*isn|get +.*\*isn) If someone is wondering, I'm working ...

This is one of my stupid questions. I work so much in TP, and I just assume the rest of the world plays catch, though perhaps it does not. Is \i something unique to TP? It seems so simple and logical that I assumed it was part of Regex. However, it appears that perhaps I assumed incorrectly and this...

I too have an UltraEdit license. For hex viewing, I like it and it's convenient. However, I've broken it's RE more than once, and I rely upon RE with my life, almost.

Much of my work truly revolves around TP. I would probably be lost without it. Over the last 18 months, I've been working as a Data Warehouse DBA, which is something of a transition after 25 years as an Application Developer, 24 of those in COBOL, 23 on the Mainframe. It does throw challenges at me ...

Much appreciated

Recently had the need to sort and remove duplicates from a 125 MB file with about 8.5 million records, that reduced down to about 10 unique records. Wondered about how well it would hold up to something more vigorous. So I cloned the data to build a 1.5 GB file with 100 million records. Took about 1...

Broken again in 8.x

Echoing this sentiment

Ctrl+End for DocumentEnd

Not a search, but a valid keystroke sequence

Try here. May also work for Win7.

https://support.microsoft.com/en-us/kb/310441

SE is a strange and wonderful place