Duplicate entries based on dates

[#1]

Hi there,

I'm looking for a way of splitting a list based on the DEnd date.

When the DEnd is different to the DStart, I need to create one entry by month covered by incidents.

INPUT

SET TimestampFormat = 'M/D/YYYY';

LOAD * INLINE

Incident,      DStart,        DEnd,          Business impacted

Incident 1,   1/10/2013,   2/10/2013,    Layers

Incident 2,   1/1/2013,     4/2/2013,     Hotliners

];

OUTPUT

Incident,      DStart,              DEnd,          Business impacted

Incident 1,     1/10/2013,      1/31/2013      Layers

Incident 1,     2/1/2013,        2/10/2013      Layers

Incident 2,     1/1/2013,       1/31/2013,      Hotliners

Incident 2,     2/1/2013,       2/30/2013,      Hotliners

Incident 2,     3/1/2013,       3/31/2013,      Hotliners

Incident 2,     4/1/2013,       4/2/2013,       Hotliners

Hope the output is clear enough.

Thanks in advance