Replace Spaces with New Lines in Comma-Separated Number Lines
I have a list like following:
\u042f 12,197,051
\ube44\ud574 93,721,409
HUMAN 45,754,677
Overwatch 43,437,031 OVERWATE
Now I want to replace spaces with new lines in Comma-Separated number lines like following results:
\u042f
12,197,051
\ube44\ud574
93,721,409
HUMAN
45,754,677
Overwatch
43,437,031
OVERWATE
I tried following regex:
Find What: (^\h*)(.*?)(\h*,.*$)
Replace With: \1\2\n\3
But it not working good and provide me following results:
\u042f 12
,197,051
\ube44\ud574 93
,721,409
HUMAN 45
,754,677
Overwatch 43
,437,031 OVERWATE
Where is my regex problem?
Solution
If you want to replace leading spaces before comma separated numbers:
\h+(\d+(?:,\d+)+)(\h+)?
The pattern matches:
\h+Match 1 or more horizontal whitespace characters(\d+(?:,\d+)+)Capture group 1, match 1+ digits and repeat 1 or more times a comma and again 1+ digits(\h+)?Optional group 2, match 1 or more horizontal whitespace characters
See a regex demo
In the replacement a newline followed by the group 1 value, and if there is a group 2 value append another newline using a conditional:
\n$1(?{2}\n)
- Return elements from a list that match a pattern
- convert/compile regular expressions to C code
- How to make the regex negative lookbehind consume discarded text?
- Generate words that fit in Guids (just for fun)
- Insert newlines before sequences of all-caps words
- Convert all uppercase words in a string to title case
- Add a character in between regex
- RegExp testing fails when string is validated in RegExp tools
- VSCODE snippet PHP to fill namespace automatically
- Regular expression to extract text between square brackets & last string out of the square bracket
- What is the difference between a plus and a star in regex?
- Extract class names from JAR with special formatting
- How to replace a comma with a dot in a number (or any replacement)
- regex to match at certain string and not followed by another string using notepad++
- RegEx for matching UK Postcodes
- Why does the grep command select more than expected?
- Regex for ISO 8601 durations
- Regular expression for number with length of 4, 5 or 6
- Regex to match a whole number not ending in some digits
- Can anyone lead me to DEFINE assertions documentation for regular expressions?
- Regex to find string not followed by separator and 1 or 2 digits
- Regex for quoting unquoted XML attributes
- Regex to extract all the rows from CSV - Apache Nifi
- 12-digit regex for phone number
- regex to exclude lowercase only strings, but save strings which contain capital
- Extract year with an optional plus right after from a string using PHP regex
- missing quotation marks on keys in JSON
- Regex for a valid hashtag
- Enumerate Possible Matches of Regular Expression in Java
- camelCase to underscore in vi(m)