How to Find all comma and replace it with a Hard Return (HRT)
-
Hi,
I have a single line txt file withRobert Long robert.long@xxxx.com, Michael Long m.long@xxxx.com, . . . .
What I want to do is have a hard return at each comma (removing the comma if possible)
Thank you
-
- FIND = “,\h*”
- REPLACE = “\r\n”
- Search Mode = regular expression
- REPLACE ALL
-—
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 clipbpard to your post usingCtrl+V. 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. -
This post is deleted! -
@PeterJones Awesome! Thank you
I forgot to do Regular ExpressionThank you for the quick reply
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login