Regular Expressions

12-Oct-23 0:47

Good morning everyone,
I can't use regular formulas

I basically have to look for initials

(jolly)"se_meta":90

And I have to replace

Work09Document2023”se_meta”:90

Thanks and best regards

Roberto Grigis

OriginalGriff12-Oct-23 0:50

12-Oct-23 0:50

Quote:
I can't use regular formulas

Because you aren't allowed to, or because you don't know how to? It makes a big difference in the answer ...

What have you tried?
Where are you stuck?
What help do you need?

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Luca Smith12-Oct-23 0:54

12-Oct-23 0:54

I can’t use regular formulas

I have all the files containing:

Work09Document2022"se_meta":9001
Work09Document2022"se_meta":9002
Work09Document2022"se_meta":9003
Work09Document2022"se_meta":9004
Work09Document2022"se_meta":9005
.
.
.
(and so on)

I basically have to look for initials
(Wildcard)"se_meta":90

And I have to replace

Work09Document2023"se_meta":90

Thanks for your help

Roberto Grigis

OriginalGriff12-Oct-23 1:18

12-Oct-23 1:18

At the risk of repeating myself...

Quote:
Because you aren't allowed to, or because you don't know how to? It makes a big difference in the answer ...

What have you tried?
Where are you stuck?
What help do you need?

Luca Smith12-Oct-23 1:40

12-Oct-23 1:40

For the REGEX program or also NOTEPAD++

Thanks and best regards

Dave Kreskowiak12-Oct-23 3:02

Dave Kreskowiak

12-Oct-23 3:02

What's a "regular formula"? Are you talking about "regular expressions"?

You're not going to get any answers to whatever question you have until you spell out, in detail, the actual question.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.
Dave Kreskowiak

Richard Deeming12-Oct-23 1:45

Richard Deeming

12-Oct-23 1:45

For a manual process, use something like PowerRename[^].

If you want to do this in code, you're going to need to provide a lot more detail. But since you keep ignoring OG's questions, I won't hold my breath.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Luca Smith12-Oct-23 1:59

12-Oct-23 1:59

Thanks for your help,
that's not what I'm interested in. Find and replace within the file

Dave Kreskowiak12-Oct-23 3:01

Dave Kreskowiak

12-Oct-23 3:01

STOP TYPING AS LITTLE AS POSSIBLE AND ACTUALLY EXPLAIN WHAT YOU'RE HAVING A PROBLEM DOING!!!!

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.
Dave Kreskowiak

Terry R 202313-Oct-23 9:22

Terry R 2023

13-Oct-23 9:22

Given the conversation here and that you were equally sparse on words in your question on the Notepad++ forum https://community.notepad-plus-plus.org/topic/25021/regular-formulas it does seem that you don't read the replies properly and respond with a LOT more information.

If it wasn't for the pigeon English feel I'd almost say this is an AI conversation.

Terry

OriginalGriff12-Oct-23 2:38

12-Oct-23 2:38

I think we are witnessing a Miracle Of Life: the birth of a Help Vampire. Fascinating - you don't often get to see them in the wild until they are at least 3 years old ... Big Grin | :-D

Regular Expression for a repeating pattern?

jschell12-Oct-23 5:21

jschell

12-Oct-23 5:21

Luca Smith wrote:
NOTEPAD++

Following has basics of a replacement for Notepad++ using regular expression. You will need to adjust for your needs.

Find/Replace with Regex and Wildcard in the middle of the strings | Notepad++ Community[^]

Les Stockton6-Oct-23 7:50

Les Stockton

6-Oct-23 7:50

I've got some data input by a user.
it's like <span>    </span> and this can be any number of this non-breaking space up until the close of the span tag, with nothing else.
I'm trying to figure out a reasonable way to be able to detect an occurance of a span like this. It would be the span and then 30 occurances of the non-breaking space, or it could be 300 occurances, or any number between.
I was hoping there'd be a way to detect this repeating pattern within a regular expression.

XML

<span>&nbsp; &nbsp; </span>

PIEBALDconsult6-Oct-23 7:59

PIEBALDconsult

6-Oct-23 7:59

You might need to test for the Unicode value.

RedDk6-Oct-23 8:08

RedDk

6-Oct-23 8:08

Scarf this down:
Regex Quantifier Tutorial: Greedy, Lazy, Possessive[^]

modified 25-Oct-23 2:06am.

jschell9-Oct-23 5:26

jschell

9-Oct-23 5:26

Specifics of where/which regex is used matters.

But in general

{code}
\s*( \s*)+
{code}

Les Stockton wrote:
until the close of the span tag

In valid XML looking for the closing tag is pointless. But you can add it if you want.

Les Stockton wrote:
XML

Just noting that regexes to parse XML is not a good idea. Primarily this comes down to blocks embedded in other blocks. You cannot parse that with a regex. But there are other complex issues also that would require hideous regexes (which means slow) also.

Also there can be other variances in what you posted.
1. Multiline
2. Spaces in the tags
3. Attributes in the tag.

Exclude Uppercase for conjoined names

k50549-Oct-23 6:12

k5054

9-Oct-23 6:12

In general, trying to parse XML (or HTML) with regex is not a good idea, and almost certainly doomed to failure. However, to match this specific case you might try:

RegEx

<span>(&nbsp; *)+</span>"

That's an extended POSIX regex, and seems to do the job. It matches any of the following:

XML

<span>&nbsp;</span>
<span>&nbsp; </span>
<span>&nbsp; &nbsp; </span>
<span>&nbsp; &nbsp; &nbsp; </span>
<span>&nbsp;&nbsp; &nbsp;</span>

If you need to accept any white space you might try using ( [[:space:]]*) as the sub-pattern.
If you may have line breaks in the span text, then you may need to tell your regex engine to not treat them as end-of-text markers.

Keep Calm and Carry On

Plastmannen2-Oct-23 22:08

Plastmannen

2-Oct-23 22:08

Hello! I'm new to learning regex and I cant seem to figure out how to exclude certain characters from my regex.
In my example I want to structure names as FIRST_NAME, LAST_NAME. Meaning "Rog er , Green" becomes "Roger, Green".
Which I have acomplished with the RegEx (?=[A-Z]). My current issue is in Sweden where I recide conjoined names such as "Lars-Erik" is rather common and with my current RegEx that becomes "Lars- Erik" which I dont want.
It also does not take into account nordic uppercase letters such as Ö etc.
Is there a way of excluding Uppercase letters that have a Hyphen prefix, as well as including more than US characters?

OriginalGriff2-Oct-23 22:20

2-Oct-23 22:20

When you use square brackets, you are limiting it to just the characters (and ranges) you include within the brackets: [A-Z] includes only the characters 'A' to 'Z'. I fyou want to extent that to accented characters, you either need to add them to the brackets: [A-Za-zÄÀÉÏÔÕÖÜßàâäèéêëîôõöûüçÇ] or use the less specific "alphanumeric character" code \w instead - this has the disadvantage of including '0' to '9' as well, but ... it's a lot easier to read ... Big Grin | :-D

You can also include the hyphen in your "permitted characters" list to allow for hyphenated names: [\w-]

If you are going to use regular expressions, you need a helper tool. Get a copy of Expresso[^] - it's free, and it examines and generates Regular expressions.

Plastmannen2-Oct-23 23:25

Plastmannen

2-Oct-23 23:25

I see, \w would match all characters right? Not just Uppercase letters. So in my case I would need to individually add all Uppercase variants of accented characters into my brackers after A-Z?

OriginalGriff3-Oct-23 0:42

3-Oct-23 0:42

Yes.

Plastmannen3-Oct-23 1:04

Plastmannen

3-Oct-23 1:04

Alright thank you!