Adding commas
-
I need to add comma to each line after a number. For example if I am working with these codes:
38664
38665
44166
44167
32872
32873
173649
I need an easy way to add a comma to each line where there is none. So end result should look like this:
38664,
38665,
44166,
44167,
32872,
32873,
173649,
I tried find and replace with no success since I do not have the original value and do not know how to mark the empty space.
You assistance would be greatly appreciated. -
Fairly straightforward IF your data is truly representatitve:
Find-what box:
(\d+)
Replace-with box:\1,
Search mode:☑ Regular expressionThe explanation is:
When finding, look for the longest contiguous run of digits–the \d means digits–the + means one or more–the ( ) will cause that digit run to be remembered for the replace. When replacing, replace each match with the original run of digits plus a comma. -
You are my new ‘Rock Star!’ That worked exactly like i needed it to!!! Thanks a million!
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