I am trying to parse string from python regex-Not able get desired output

Question

sample_string = ":61:2002190219C45612.4S202EXC:OL3654628815//CT56748005:86:/BENM/Unitech Imports/REM//58970.047:61:2002190219C30000S103LCADV5674920204//CT56748006:86:/BENM/Gravity Imports/REM//INV:/FEB20/446301:61:2002190219C45612.4S202EXCOL3654628825//CT56748005:60F:61:2002190219C45612.4S202EXCOL3654628815//CT56748018"

Basically I need all

1. :61:, :86: string which are next to each other any where in the full message ex:- re.findall()=expected o/p - [':61:2002190219C45612.4S202EXC:OL3654628815//CT56748005:86:/BENM/Unitech Imports/REM//58970.047', :61:2002190219C30000S103LCADV5674920204//CT56748006:86:/BENM/Gravity Imports/REM//INV:/FEB20/446301] 
i have below regex for above case which is working fine, can we simplify a bit, 
61:(?:[\w /,.-]|:(?!61:|86:))*:86:(?:[A-Za-z0-9 /.-]|:(?!61:|86:))*
regex example - https://regex101.com/r/U3MWF7/4

2. All :61 string which are not followed by :86 anywhere in the full message, ex:- re.findall()=
expected o/p=[':61:2002190219C45612.4S202EXCOL3654628825//CT56748005',':61:2002190219C45612.4S202EXCOL3654628815//CT56748018']

I have below regex to get all :61 strings from message which is not giving correct result - its giving all :61 strings which are followed by:86 also.
61:(?:[\w /,.-]|:(?!61:|86:))*(?!:86:)* ()
regex example - https://regex101.com/r/2svNjG/1

I have tried multiple option but not able to get required output. request for help

Like this? :61:(?!.*:86).*?(?=:61:|$) regex101.com/r/zA9SFB/1 and regex101.com/r/iieEyg/1 — The fourth bird
– The fourth bird, Commented Sep 2, 2020 at 12:58

The fourth bird · Accepted Answer · 2020-09-02 13:15:11Z

2

You can match :61: and assert that what is on the right does not contain :86: Then match until the next occurrence of :61: by matching either one of the listed in [\w /.-] or match a : not directly followed by 61:

:61:(?!.*:86:)(?:[\w /.-]|:(?!61:)[\w /.-]*)*

Regex demo | Python demo

If there are multiple lines, you can make the dot match a newline using re.DOTALL or use an inline modifier (?s)

(?s):61:(?!.*:86:)(?:[\w /.-]|:(?!61:)[\w /.-]*)*

edited Sep 2, 2020 at 13:15

answered Sep 2, 2020 at 13:08

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Navneet Over a year ago

This is including :60F:, which is different string all together. :61:2002190219C45612.4S202EXCOL3654628825//CT56748005 :60F:

The fourth bird Over a year ago

@Navneet So you don't want to include a 6 followed by a digit and optional char A-Z? regex101.com/r/DzoIcc/1 or a char a-z or digit regex101.com/r/Flrlq7/1

Navneet Over a year ago

Not maching for full string regex101.com/r/Flrlq7/1

The fourth bird Over a year ago

@Navneet What do you mean by full string? You get the 2 desired matches right?

Navneet Over a year ago

Thanks @The fourth bird , still some of string are not matching but you have given enough pointers. i will look in that Thanks:)

|

Collectives™ on Stack Overflow

I am trying to parse string from python regex-Not able get desired output

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related