Click here to Skip to main content
15,900,461 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: MySQL Select query that chooses something dot something between certain underscores Pin
RedDk22-Sep-23 9:44
RedDk22-Sep-23 9:44 
GeneralRe: MySQL Select query that chooses something dot something between certain underscores Pin
RedDk19-Sep-23 8:17
RedDk19-Sep-23 8:17 
GeneralRe: MySQL Select query that chooses something dot something between certain underscores Pin
Richard MacCutchan19-Sep-23 22:09
mveRichard MacCutchan19-Sep-23 22:09 
AnswerRe: MySQL Select query that chooses something dot something between certain underscores Pin
jschell14-Sep-23 10:55
jschell14-Sep-23 10:55 
QuestionExclude already masked data in regex Pin
NathanAsh25-Aug-23 11:14
NathanAsh25-Aug-23 11:14 
AnswerRe: Exclude already masked data in regex Pin
Terry R 202325-Aug-23 12:48
Terry R 202325-Aug-23 12:48 
GeneralRe: Exclude already masked data in regex Pin
NathanAsh28-Aug-23 5:32
NathanAsh28-Aug-23 5:32 
QuestionRegEx remove duplicate need help Pin
manoo885-Aug-23 13:04
manoo885-Aug-23 13:04 
Hi, not good at RegEx and trying to remove some duplicate values.
data is in CSV, part of it looks like this:

"/content/7/66345/images/590009.jpg , "/content/7/66345/images/590009.jpg , "/attachments/fe519c1e91c5e4983a70a2512fd5788b.jpg , "/content/7/66345/images/590009.jpg , "/content/7/66345/images/590009.jpg , "/attachments/4956e4fe56b59135c086605c9gyye.png
"/content/1/3968663/images/856609.jpg , "/attachments/086605c7c6e4fe56b59135c11b.jpg , "/content/1/3968663/images/856609.jpg , "/attachments/086605c7c6e4fe56b59135c11b.jpg
"/content/1/1458767/images/856657.jpg
"/content/1/1448511/images/856373.jpg

I am trying the following using Notepad++:
\w+\.+jpg|\w+\.+png(?:^|\G)(\b\w+\b),?(?=.*\1)

it does select one image by one image when clicking find, but I am not sure how to delete duplicates,
when I replace it with empty, it removes all, I want to let the first image remain and delete the duplicates, Anyone can help me with the code, please?
I don't want to remove the line, because it could mess with the CSV file, removing the extension of the duplicate image is OK,
Thanks for your help.
GeneralRe: RegEx remove duplicate need help Pin
Member 106011917-Aug-23 12:04
professionalMember 106011917-Aug-23 12:04 
AnswerRe: RegEx remove duplicate need help Pin
Andre Oosthuizen7-Aug-23 23:27
mveAndre Oosthuizen7-Aug-23 23:27 
AnswerRe: RegEx remove duplicate need help Pin
jschell11-Aug-23 10:49
jschell11-Aug-23 10:49 
GeneralRe: RegEx remove duplicate need help Pin
trønderen11-Aug-23 12:21
trønderen11-Aug-23 12:21 
GeneralRe: RegEx remove duplicate need help Pin
jschell14-Aug-23 6:01
jschell14-Aug-23 6:01 
QuestionRegex search and replace? Tabs ... Pin
Member 1483514610-Jul-23 9:57
Member 1483514610-Jul-23 9:57 
AnswerRe: Regex search and replace? Tabs ... Pin
jschell14-Aug-23 6:13
jschell14-Aug-23 6:13 
GeneralHow to insert a space at the beginning of a line in a "for next" code loop (.NET regular expressions) Pin
Piotr Przeklasa4-Jul-23 2:20
Piotr Przeklasa4-Jul-23 2:20 
GeneralRe: How to insert a space at the beginning of a line in a "for next" code loop (.NET regular expressions) Pin
Andre Oosthuizen5-Jul-23 1:15
mveAndre Oosthuizen5-Jul-23 1:15 
GeneralRe: How to insert a space at the beginning of a line in a "for next" code loop (.NET regular expressions) Pin
Richard MacCutchan5-Jul-23 2:21
mveRichard MacCutchan5-Jul-23 2:21 
GeneralRe: How to insert a space at the beginning of a line in a "for next" code loop (.NET regular expressions) Pin
jschell5-Jul-23 5:31
jschell5-Jul-23 5:31 
QuestionNeed help with Regular expression Pin
Member 1601263423-May-23 9:36
Member 1601263423-May-23 9:36 
AnswerRe: Need help with Regular expression Pin
PIEBALDconsult23-May-23 9:39
mvePIEBALDconsult23-May-23 9:39 
AnswerRe: Need help with Regular expression Pin
jschell24-May-23 5:58
jschell24-May-23 5:58 
QuestionRedirection with exclusions RegEx Pin
Member 1598311319-Apr-23 3:07
Member 1598311319-Apr-23 3:07 
QuestionI need help with a complex regex Pin
Member 127465326-Apr-23 3:57
Member 127465326-Apr-23 3:57 
AnswerRe: I need help with a complex regex Pin
Terry R 202312-Apr-23 10:53
Terry R 202312-Apr-23 10:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.