Thanks Mr Terry R!

@guy038 Sorry for being unclear! Sometimes I read my older posts and wonder how people managed to find any sense in them. That’s why I post so rarely…

thank you

also,

a(\W+\w+){1,6}\W+for

Hello @ph0enix, @Scott-sumner and All,

if the general template of your data is always :

........@..........;......

Here are, below, 3 other possible regex S/R. Similarly to Scott’s post, you must select the Regular expression search mode, tick the Wrap around option and click on the Replace All button. Note that the Replace with: zone is always Empty

First regex :

SEARCH (?-s)@.+

REPLACE Empty

Results :

123.456.78.0:22000 12.3.456.789:10000

Second regex :

SEARCH (?-s).+?@|;.+

REPLACE Empty

Results :

Name\Name123 NAME\Name-1

Third regex :

SEARCH (?-s).+;

REPLACE Empty

Results :

name Name2017

Best Regards,

guy038

Scott, Thank you. I knew there would be a way and I almost knew it would be something in a regular expression, but only gods like yourself would know what to do. I really like the idea of a delimeter and then using the search to match any above and below the line.

I did not get the chance to try this (although I can’t see why it wouldn’t work) as I thought of an alternative, which was to use Excel and a formula. I managed to open each of my 5 files in one workbook with seperate tabs and use a formula to look at a control tab to find any matches. I think it’s pretty much the same thing as your suggestion, just using vba and not regex.

I thank you for your efforts

@Allan-Biggs

Try pressing Alt+Home in your macro where you are pressing Home.

@C-Ananda-Rao

Well, when I asked for data, I guess I should have asked for an explanation of that data to accompany it… I suppose I assumed that the phone number was the last part of every line where digits were present. Anyway, hopefully @guy038’s response provides the help you needed.

Well @John-Drachenberg I’d try and grab the records in the group of 5 lines from the date added to the url line, combining them all into 1 line (so replacing CR/LF) with some other delimiter. I’d then create a "key at the start of the line, possibly the main part of the url, excluding any /folder names. Sort all the lines so that it would easily match up possible duplicate urls. To my mind a duplicate is any url where even if the /folder names/ portion was different would warrant further inspection.

At this point either eyeball the duplicates, or another regex could mark possible duplicates for further inspection.

Not sure if you actually want a regex to just remove duplicates in the original file, or would be happy just getting a list of possible duplicates which you could then check against the original and remove manually.

Terry

@Alain-Torrens

Settings (menu) -> Preferences… -> Editing (box on left) -> Caret Settings -> Width can get you a much more visible caret/cursor…but not everything you’ve requested.

@Rasmus-van-moortel

can someone please help me?

Nope, not without more detail than that…hint: show some before and (desired) after data.

@Terry-R said:

Note that I have used the “” character before some,

I think this is supposed to read:

Note that I have used the “\” character before some,

https://github.com/pnedev/compare-plugin/releases

Thanks for the heads up. I hadn’t thought of that.

Maybe a “Recent News” thread? :)