Parsing Primavera P6 dbo.CALENDAR [clndr_data] field

Primavera P6 Enterprise v 16.2

SQL Server 2014 (12.0.4100.1)

Hi All,

Can anyone provide me with a guide or perhaps even a script for parsing the Primavera P6 dbo.CALENDAR [clndr_data] field? I would be happy if there is something in T-SQL or C#, or even just a guide.

I have a requirement to put 100s of calendars into a tabular format, and to interpret new calendars as they are created.

Best regards,

Carl

Example data: in one cell of dbo.CALENDAR [clndr_data] field

(0||CalendarData()(

 (0||DaysOfWeek()(

  (0||1()(

   (0||0(s|00:00|f|00:00)())))

  (0||2()(

   (0||0(s|00:00|f|00:00)())))

  (0||3()(

   (0||0(s|00:00|f|00:00)())))

  (0||4()(

   (0||0(s|00:00|f|00:00)())))

  (0||5()(

   (0||0(s|00:00|f|00:00)())))

  (0||6()(

   (0||0(s|00:00|f|00:00)())))

  (0||7()(

   (0||0(s|00:00|f|00:00)())))))

 (0||VIEW(ShowTotal|N)())