Show the data you have and the text you want to get from that data include examples of things that should match and be transformed, and things that don’t match and should be left alone show edge cases and make sure you examples are as varied as your real data. Screenshots can be pasted from the clipboard to your post using Ctrl+V to show graphical items, but any text should be included as literal text in your post so we can easily copy/paste your data. All example text should be marked as plain text using the toolbar button or manual Markdown syntax.
FIND = (?-s)^(.*(,".*?",).*$\R)(^.*\2.*$\R*)+Ĭonverts into For more on how each piece of the regex works, see here, which if you click on EXPLAIN in the lower half will give the details of the individual elements of the regex used see the links below for finding more on Notepad++'s Boost regular expressions, as well as a FAQ with other regex links.ĭo you want regex search/replace help? Then please be patient and polite, show some effort, and be willing to learn answer questions and requests for clarification that are made of you. If it doesn’t work for you, you’ll need to clarify things for us. Making one possible set of assumptions about your data (different URLs, ASCII quotes, always adjacent lines), I can craft the following. Is that URL always the same, or is it different line-to-line? Because someone might craft a regex that matched your example, but then expects the opposite of what you actually have, so it won’t work for you.Īlso, are those quotes real ASCII quotes, ", or are they the “smart quotes” “” that the forum shows? Because that changes the regex.Īlso, are the near-duplicates always next to each other, like you’ve shown?įollowing the advice at the end of my post will help you clarify this question, including formatting and before/after requests, will help you get better answers.
0 kommentar(er)
