Community

I have TextPad open with a Workspace, I have .txt files associated with TextPad from within TextPad, and I have Allow Multiple Instances To Run unchecked.

When I double click on a .txt file, it opens in a new instance of TextPad. I have to right click on the file, and select Open with TextPad in ...

I should be clear, the data itself changes.

A sort order looking at the number as characters makes total sense.

But I'm seeing that the data itself changes.

I have a plain text data file of just under 100K rows. The data are all 5 to 8 digit numbers.

I sort it using

First Key From: 1
First Key Length: 10
Sort Order: Ascending
Comparison: Case insensitive or Case sensitive

The data becomes garbled.

I know that I should be using Comparison: Numeric ...

I bet that is not the regex you wanted to post, because without the backslashes you surely are unable to get numbers.

Yours works, but I'm puzzled why mine blew up TP. I tried it in Expresso, and it understood it. Tried it in another tool, and it worked fine.

Update: Now I'm seeing that it ...

Here is a sample of the text. SQL Server Message Results, and I was trying to get just the numbers to add them up [by then copy and pasting into Excel].

(1000 rows affected)

(1000 rows affected)

(1000 rows affected)

(1000 rows affected)

(1000 rows affected)

(1000 rows affected)

(1000 rows ...

I tried changing this:
^\D*(\d+)\D*$

To this:
$1

And crash

That was the trick, Mudguard! Many thanks! You truly Grok in Full!

I'm trying to match on a SQL INSERT statement, but only up to the first GO statement. I think I need Negative Lookbehind assist, but I could not make it work.

This will keep finding until the LAST GO statement, but I only want the NEXT GO statement after the INSERT.

insert +into +dbo.account .*GO

I'm using 8.5.1, and it only works if I have two TP sessions up

I did put Nevermind in the subject

Weird proxy issues here, I'm thinking.

I've tried a couple of links that I thought might work. Nothing.

This also works

[\x{007F}-\x{FFFF}]

That is fascinatingly strange. And it works. Much appreciated.

It appears I'm going to have to become much more connected with UTF-8 and Unicode and BOMs, oh my.

I'm trying to use the Regex Range of [\x7F-\xFF], but it does not appear to work. I can find some characters in the range, but not everything.

Here are two specifics.

I cannot find the left single quote (‘).
ALT-0145 on the keyboard.

I can find the latin small letter y with diaeresis (à...