@Bharath-k said in Is there way to Search for duplicate records based on the column in notepad++ and delete the particular row:
actual data i am not able to publish here due to its client data and i am not allowed to share.
We understand that. When your “data sanitization” (removing secret info) is just putting in fake numbers and fake names (even fake column headers if you want), that’s one thing; the regex will likely still work, as long as it has the same type and width of data in each column. However, in your first post, you not only “sanitized” the data, you also changed the number of columns – that means that the regex is likely to change, because number of separators will be different, etc.
The advice below might help you ask better questions next time, and reduce the number of back-and-forth exchanges before you have a working solution.
----
Do 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. All example text should be marked as plain text using the </> toolbar button or manual Markdown syntax. 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. 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. Show the regex you already tried, and why you thought it should work; tell us what’s wrong with what you do get… Read the official NPP Searching / Regex docs and the forum’s Regular Expression FAQ. If you follow these guidelines, you’re much more likely to get helpful replies that solve your problem in the shortest number of tries.
