Python Forum
Split string between two different delimiters, with exceptions
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Split string between two different delimiters, with exceptions
#1
I couldn't really think of a good title for this, so, sorry!

Say I have some data like so:
:1:123456:2:name:42:3:30:4::5:somerandomdata:9:8
The important data is held between groups like :1:. Each of those groups has a different number from the next. I need to split the string between all of those groups so I can access that data. But due to some issues with the data I'll explain, it's not as easy as just splitting.
In the above data I have tried to include all the edge cases:
- The numbers of the groups are not in any specific order. Generally they are ascending but some will be out of order
- The groups numbers are between 1 and 2 characters
- Some groups will be empty like :4::5:
- One groups has a time which has a colon in it: :42:3:30:4: (the time being 3:30). This will mess up most already existing split functions.
In the data above, all actual data between the groups is hard coded. In the PHP file this comes from, most of that data is from many variables which explain what that data is. However some of the data is just constant values like 1 and I don't know what they do. In the data above I made :9:8 the "unknown constant".

My current approach has a class full of values like this:
class DataValues:
    _ID = 1
    NAME = 2
    TIME = 42
    SOMETHING = 4
    DATA = 5
    CONSTANT = 9
Each variable is in the order like in the data. To split I do this:
s = []
_vars = [getattr(DataValues, v) for v in vars(DataValues) if not v.startswith("__")] #loop through the variables in the class
for i in range(len(_vars) - 1):
	split = re.search("(:{}:)(.*)(:{}:)".format(_vars[i], _vars[i+1]), self.data)
	split = "" if split is None else split.group(2)
	s.append(split)
This works for the most part. It has 1 issue where the regex just doesn't split the string like so :2:Sidestep:3:VXBkYXRlOiBhZGRlZCB (It should have split between 2 and 3).
The code also relies on the class having every single value in the exact order of the data. If anything was changed in the data it would break. It also involves me having these "constant" values which are unknown and so it makes the code messy because I have to create variables like UKNOWN_1 = 8.

Could anyone help me out on this?
Reply


Messages In This Thread
Split string between two different delimiters, with exceptions - by DreamingInsanity - Aug-23-2020, 04:03 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Parse String between 2 Delimiters and add as single list items lastyle 5 144 Apr-11-2021, 11:03 PM
Last Post: lastyle
  Python, exceptions KingKhan248 6 411 Nov-15-2020, 06:54 AM
Last Post: buran
  handling 2 exceptions at once Skaperen 2 552 Jun-27-2020, 08:55 AM
Last Post: Yoriz
  remove spaces with exceptions catosp 4 610 May-29-2020, 09:32 AM
Last Post: catosp
  split string enigma619 1 421 May-20-2020, 02:47 PM
Last Post: perfringo
  Split string with multiple delimiters and keep the string in "groups" DreamingInsanity 4 1,145 May-12-2020, 09:31 AM
Last Post: DeaD_EyE
  Problem with delimiters johnprada 5 827 Jan-29-2020, 10:17 AM
Last Post: DeaD_EyE
  Problem with delimiters johnprada 1 493 Jan-28-2020, 04:27 PM
Last Post: buran
  splitting a string with 2 different delimiters Skaperen 4 838 Dec-30-2019, 04:49 AM
Last Post: BamBi25
  Split a long string into other strings with no delimiters/characters krewlaz 4 772 Nov-15-2019, 02:48 PM
Last Post: ichabod801

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020