Which serialization format is this?

Question

I’m dealing with some serialized data fetched from an SQL Server database and that looks like this :

('|AFoo|BBaar|C61|DFoo Baar|E200060|F200523|G200240|', )

Any idea which format is this ? And is there any Python package that can deserilize this ?

Answer 1

What you show is a tuple that contains one value - a string. You can use string.split to construct a list of the string's component parts - i.e., AFoo, BBaar etc

t = ('|AFoo|BBaar|C61|DFoo Baar|E200060|F200523|G200240|', )

for e in t:
    values = [v for v in e.split('|') if v]
    print(values)

Output:

['AFoo', 'BBaar', 'C61', 'DFoo Baar', 'E200060', 'F200523', 'G200240']

Note:

The for loop is used as a generic approach that allows for multiple strings in the tuple. For the data fragment shown in the question, this isn't actually necessary