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)
- Java regex for URL
- Perl last capture match variable
- Issue while masking Credit Card No. before and/or after spaces
- Extracting a numeric value from the middle of a String field in MS Access 2016
- Datadog Regex is not replacing the right data
- How to parse pdf in r and then correctly convert or extract spaced/tabbed pieces of text into columns of dataframe?
- Does there exists a PowerShell Escape function for Special Characters
- regex for semver
- How to use PHP to echo entire word with occurance of character sequence?
- How to extract or capture the value from stdout_lines of an Ansible playbook?
- PCRE Regex to SED
- Parsing formulas efficiently using regex and Polars
- Regex - check if input still has chances to become matching
- Commenting Regular Expressions
- Add space after specified data using regular expression in Visual Studio
- Regular Expression to collect everything after the last /
- python regex to get text within a pattern defined
- Python regex for Java annotations
- How to limit/cap values exceeding a certain value in Notepad++
- Replace variables in a formula with their definitions
- How do I fix this Reg ex so that it matches hyphenated words where the final segment ends in a consonant other than the letter m
- How to match strings having optional group and not containing specific group?
- Using Regex to get multiple data on single line by scraping stocks from yahoo
- Javascript regular expression password validation having special characters
- php extract only selected rows from external table
- A regexp to retrieve either og:url meta or link rel="canonical"
- Extract all matching font-family attributes from string
- Using callable_iterator (re.finditer) causes Python to freeze
- Replace Spaces with New Lines in Comma-Separated Number Lines
- R split 1 column into several columns based on regex value