Regex to find any lines that do NOT have a specific number of a character

Mark Yorkovich

@Mark-Yorkovich
because it was assumed that all columns contain data

My bad. I didn’t give you all of the details of what I’m working with.

find: ^(?>.*?\|){9}(?!.*?\|) does not make that assumption.

This works.

So at this point what I’d need to do, ideally, is to do a Find/Replace, finding all of the new line/line feed characters - only in those now-bookmarked lines - and replace them with some other character (spaces, dummy chars, whatever) to get each of those records to be on one line. Can I do a find/replace on just the bookmarked lines? Or perhaps, instead of the multi-step approach, is there a way to do this on the Replace tab, entering a regex in the Find what box that finds those lines and just replace the new line characters with dummy characters in one step?

Alan Kilborn

@Mark-Yorkovich said:

Alan’s exp doesn’t match anything in my file

Well, if I copy and paste your “lorem ipsum” data (above) into a new tab and then run my regex (above) on it, I get lines with exactly 9 pipes redmarked, which I thought was the goal (or the inverse of the goal):

Imgur

So…I really don’t know where the disconnect is…

Alan Kilborn

@Mark-Yorkovich said:

…finding all of the new line/line feed characters - only in those now-bookmarked lines - and replace them with some other character (spaces, dummy chars, whatever) to get each of those records to be on one line

Didn’t we do all this the other day?

Allen Bai

(.|){9}.

how about this?

Ekopalypse

@Allen-Bai

I assume you meant (.\|){9}.
This matches 9 and more pipe delimited lines.

Allen Bai

This post is deleted!

Allen Bai

@Ekopalypse said:

@Allen-Bai

I assume you meant (.\|){9}.
This matches 9 and more pipe delimited lines.

in fact, I mean…

（。＼｜）｛９｝。＊

but it can’t show correctly, and I don’t know how to put screenshot

PeterJones

@Allen-Bai said:

it can’t show correctly,

To quote my boilerplate:

This forum is formatted using Markdown, with a help link buried on the little grey ? in the COMPOSE window/pane when writing your post. For more about how to use Markdown in this forum, please see @Scott-Sumner’s post in the “how to markdown code on this forum” topic, and my updates near the end. It is very important that you use these formatting tips – using single backtick marks around small snippets, and using code-quoting for pasting multiple lines from your example data files – because otherwise, the forum will change normal quotes ("") to curly “smart” quotes (“”), will change hyphens to dashes, will sometimes hide asterisks (or if your text is c:\folder\*.txt, it will show up as c:\folder*.txt, missing the backslash).

For images: upload image to imgur. embed images with the syntax ![](http://i.imgur.com/QTHZysa.png). (please use imgur’s “direct link” with i.imgur.com as the hostname and the appropriate .png or .gif extension, rather than the “image” link, which really links to the HTML-wrapper, and will not embed in the forum)

Allen Bai

@Allen-Bai said:

(.|){9}.

how about this?

in fact, I mean
（。＊＼｜）｛９｝。＊

PeterJones

@Allen-Bai said:

in fact, I mean
（。＊＼｜）｛９｝。＊

Then why not put it in tick marks? Both the help I linked to and the “how to use markdown code” post explained how to do that, as did my boilerplate text itself.

`(.*\|){9}.*`

renders as

(.*\|){9}.*

Allen Bai

ah…

understand now, thank you so much

guy038

Hi, @mark-yorkovich, and All,

See my very late regex solution , below :

https://community.notepad-plus-plus.org/post/47905

Best Regards,

guy038