Regular Expressions

29-Dec-20 0:47

Hello Community,

I have created Regex with Regex Magic with HTML 5 Firework, see attached.

The Regex [A-Za-z]{3}\d{4} successfully finds a string such as GMK6954 using Character Spaces.

Can someone help with modifying the Regex such that it replaces the first 3 letters with --- so the resulting Regex will generate the following

6954

Thanks

OriginalGriff29-Dec-20 0:54

29-Dec-20 0:54

Change you digits to a "excluded suffix" and use String.prototype.replace() - JavaScript | MDN[^]:

[A-Za-z]{3}(?=\d{4})

"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!

Member 1357268429-Dec-20 1:04

29-Dec-20 1:04

Hi Griff,

Thanks for reaching out. Unfortunately, it didn't work.

The replacement just returns

[A-Za-z]{3}(?=\d{4})

OriginalGriff29-Dec-20 1:39

29-Dec-20 1:39

And how - exactly - did you try it?

Member 1357268429-Dec-20 1:51

29-Dec-20 1:51

Is it possible to send an attachment on this forum

I would like to send a screenshot to you.

OriginalGriff29-Dec-20 2:23

29-Dec-20 2:23

No. Copy'n'paste the relevant code fragments.

Member 1357268429-Dec-20 9:20

29-Dec-20 9:20

Hi, sorry for the delayed response.

I wanted to show you a screenshot, because I'm not getting an error from the application I'm using. It's replacing the string with [A-Za-z]{3}(?=\d{4})

Let me know if you can see the screenshot from the link below?

regmagic2.png - Google Drive[^]

OriginalGriff29-Dec-20 9:35

29-Dec-20 9:35

And what do you think that tells me about how you coded it?

To quote myself:

Quote:
And how - exactly - did you try it?

If you go for a drive and break down, when you call the garage, do you send them a picture of the view you can see out the car window? Or tell them what happened and where you are?

Member 1357268429-Dec-20 9:45

29-Dec-20 9:45

I dont understand.

Did you see the screenshot?

I simply cut-and-paste your regex

I should point out the regex I originally sent was not generated by me - I simply got the regex using an application called RegexMagic.

I am 100% new to Regex.

This means, I really don't have a clue what you're referring to.

Please help

OriginalGriff29-Dec-20 10:05

29-Dec-20 10:05

Code.

A regex doesn't exist in isolation - it has to be used in code in order to do anything. On it's own, it's just a string ...

Dave Kreskowiak29-Dec-20 16:15

Dave Kreskowiak

29-Dec-20 16:15

What does it take to get you to copy and paste the code you're using where you're setting up and using this RegEx?

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

Dave Kreskowiak

Member 1357268430-Dec-20 11:08

30-Dec-20 11:08

Hi Dave,

Sorry for the delayed response

The reason for wanting to show a screenshot is because I use application to insert the a Search and Replace regex. So I would enter [A-Za-z]{3}\d{4} in the Search dialogue box, and [A-Za-z]{3}(?=\d{4}) in the replace dialoge box.

The search regex works fine, but the replace regex returns [A-Za-z]{3}(?=\d{4})

I'm assuming the the Regex pattern HTML 5 FireFox doesn't allow for replace?

Dave Kreskowiak30-Dec-20 11:47

Dave Kreskowiak

30-Dec-20 11:47

You're making a lot of baseless assumptions and STILL not providing what is needed to solve the problem.

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

Dave Kreskowiak

Member 1357268430-Dec-20 11:54

30-Dec-20 11:54

Dave,

I'm not sure I could be any clearer.

If you looked at the image you would see exactly what happens when I insert the Regex

Case Conversion Regular Expression in JAVA 8

Dave Kreskowiak30-Dec-20 11:57

Dave Kreskowiak

30-Dec-20 11:57

Never heard of DataCleaner. Don't use it and not going to start.

If it's some tool you found somewhere, your best source of support is going to be whoever wrote it.

Your BIGGEST mistake was never telling anyone you were using some tool to do this work instead of writing your own code to do it.

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

Dave Kreskowiak

Member 1357268427-Dec-20 22:13

Re: Case Conversion Regular Expression in JAVA 8

27-Dec-20 22:13

Hi Community,

I have come to the conclusion that it may not to be possible to change the case of a string in JAVA 8 as simply as it is to change the case in say Perl.

However, before I move on, I just wanted to have someone on this forum confirm its not possible to change the case in JAVA 8 as follows:

Insert the whole regex match or the 1st through 99th backreference with the first letter of each word in the matched text converted to uppercase and the remaining letters converted to lowercase.

Example

Replacing .+ with \I0 in HeLlO WoRlD yields Hello World

Can someone confirm that the above isn't possible with JAVA 8?

If its not possible, can someone let me know how to achieve the above with JAVA 8?

Thanks

Richard MacCutchan27-Dec-20 22:48

Richard MacCutchan

27-Dec-20 22:48

I suggested to you last week that it would be easier to use string functions to do what you want. Convert the entire string to lower case, then find each word beginning and convert the single letter to upper case.

Re: Case Conversion Regular Expression in JAVA 8

Member 1357268428-Dec-20 8:30

Re: Case Conversion Regular Expression in JAVA 8

28-Dec-20 8:30

Hey Richard,

I was so fixated with the way I wanted to achieve the result that I didn't realise how easy it is to get the result using your suggestion. TBH, with your suggestion I can get the result just using SQL, converting the entire string to lower case (as you suggested) and using a simple SQL function (which I'm familiar with) to Capitalize each word.

I literally would have saved myself 9 hours of trying to figure this out.

Thanks man

Member 1357268428-Dec-20 8:32