Regex to exclude specific special characters, spaces and alphabets

Question

I want a regular expression which converts this:

91009-01-28-00 Maximum (c/s)................  1543.5

to this:

91009-01-28-00    1543.5

So basically, a regular expression that escapes alphabets, spaces, forward slashes and brackets.

I have written the following python code so far:

with open('lcstats.txt', 'r') as lcstats_file:
        with open (lcstats_full_path + '_lcstats_full.txt', "a+") as lcstats_full_file:
            lcstats_full_file.write(obsid )
            for line in lcstats_file.readlines():
                if not re.search(r'Maximum [(c/s)]', line):
                    continue
                line = (re.sub(**REGEX**,'',line))  
                lcstats_full_file.write(line)

Your expected output implies, at least to me, that you want to remove every characters which is not a digit, a dot (when appearing inside a number), or a hyphen. Is this the case? — Tim Biegeleisen, Aug 06 '18 at 12:59
The `(` and `)` should have been escaped, not placed inside `[...]` — Wiktor Stribiżew, Aug 06 '18 at 20:54

score 2 · Answer 1 · answered Aug 06 '18 at 13:15

2

It appears you want to have first and last part of the string. If that is the case for every line than spliting it accordingly can be helpful, as in the following code

import re
line = "91009-01-28-00 Maximum (c/s) ................  1543.5"
line=line.split(' ')
line=line[0]+' '+ line[-1]
print(line)

Output:

91009-01-28-00 1543.5

answered Aug 06 '18 at 13:15

khaldi

472
7
15

I want to do it with regular expressions. – Neal Titus Thomas Aug 07 '18 at 05:37

The fourth bird · Accepted Answer · 2018-08-07T08:31:30.970

1

In your code you are using search to check if you can match Maximum (c/s) and then you want to use a regex to remove that.

I think with your regex Maximum [(c/s)] you mean Maximum \(c/s\). The square brackets make it a character class and (c/s) captures c/s in a capturing group which is not required if you only want to match it.

Wat you could do is match Maximum (c/s) and match one or more times a whitespace or a comma using a character class [ .]+ and replace with an empty string.

Maximum \(c/s\)[ .]+

import re

s = "91009-01-28-00 Maximum (c/s)................  1543.5"
print( re.sub(r"Maximum \(c/s\)[ .]+", "", s))

Demo

edited Aug 07 '18 at 08:31

answered Aug 06 '18 at 16:11

The fourth bird

154,723
16
55
70

This just removes the . (fullstops). I want to remove 'Maximum (c/s)' too. – Neal Titus Thomas Aug 07 '18 at 05:37
1

@NealTitusThomas I have updated my answer and removed the capturing group. – The fourth bird Aug 07 '18 at 06:13

score 0 · Answer 3 · answered Aug 06 '18 at 13:12

0

Try using this regex /\s[^0-9]+/ This will match from the first space followed by 1 or more not digit characters. You will need to add a space in the replacement string to keep the two bits of remaining data separate.

answered Aug 06 '18 at 13:12

JGNI

3,933
11
21

TheMaster · Answer 4 · 2018-08-06T13:26:58.933

0

Regex:

((?<!\d)\D)

Match all non digits\D which is not followed by a digit \d

edited Aug 06 '18 at 13:26

answered Aug 06 '18 at 13:21

TheMaster

45,448
6
62
85

This converts 91009-01-28-00 Maximum (c/s)................ 1543.5 to 91009-01-28-00Maximu(c/s1543.5 – Neal Titus Thomas Aug 07 '18 at 06:10

Regex to exclude specific special characters, spaces and alphabets

4 Answers4