How to include space in the current regex answer to do the following?

Question

I would like to convert this:

ATOM   6990  CB  ILE A 1028     -0.558  90.754  9.341  0.00  0.00    +0.015 C
ATOM   6991  CB  ILE A 1028     -0.558  90.754  19.341  0.00  0.00    +0.015 C

Into this:

ATOM   6990  CB  ILE A 1028     -0.558  90.754   9.341   0.00  0.00    +0.015 C
ATOM   6991  CB  ILE A 1028     -0.558  90.754  19.341   0.00  0.00    +0.015 C

I tried using lookahead but my simple alteration to the current answer did not work for me. As i have a lot of similar anomalies i have to use regex.

Please give examples which should match and a few similar ones which however should NOT match. — Yunnosch, Sep 28 '19 at 07:28
I have no idea what you are trying to do here. The input and output look almost identical. — Tim Biegeleisen, Sep 28 '19 at 09:47
sorry i just edited it again. It is the first line at 9.341 which misses one space. — falldses, Sep 28 '19 at 09:48
Regex alone isn't the right tool for this job. You need to go back to whatever generated this tab-delimited file and re-export with fixed column widths. — Tim Biegeleisen, Sep 28 '19 at 09:55
Thats my biggest fear because it is not possible :(. I can try using a regex generator with the dataset if this is too complex. — falldses, Sep 28 '19 at 10:04
You removed all information on your attempts, your thinking, your code. This is unwise, since it gives the impression of being a "give the code" question. Please edit the question so that it provides all information. — Yunnosch, Sep 28 '19 at 11:24

score 0 · Answer 1 · answered Sep 28 '19 at 07:36

0

\d+(\s+)

Decimal digits followed by whitespace in a capturing group.

answered Sep 28 '19 at 07:36

askaroni

753
2
8

score 0 · Accepted Answer · answered Sep 28 '19 at 07:36

0

If the number of digits be fixed, e.g. at 5, you could use a fixed width positive lookbehind followed by some sort of capture group, e.g.

(?<=[0-9]{5})(\s+)

answered Sep 28 '19 at 07:36

Tim Biegeleisen

387,723
20
200
263

and how do i use it in reverse? lets say i have (tab)10002? (\t+)(?<=[0-9]{5}) would not work. – falldses Sep 28 '19 at 07:57
Use a positive _lookahead_, maybe `(\s+)(?=[0-9]{5})` – Tim Biegeleisen Sep 28 '19 at 07:59
Please edit your question and tell me what you are trying to do here. – Tim Biegeleisen Sep 28 '19 at 09:40
Okay. Done! :)) had to edit twice. – falldses Sep 28 '19 at 09:45

How to include space in the current regex answer to do the following?

2 Answers2