@guy038 said: Replace All Hello @guy038 , Thank you very much! It worked like magic!!! And your crystal cleared explaination make a dummy like me can get to understand. Surely, I need to start to learn about regular expressions. Best Regards, Wanderoz

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.