Parse Individual Characters into a Normalized Calendar

[engelwood]

I have a file (source is a MRP shop floor calendar) where each character in a single field represents the daily availability of the work center. E.G. "" = Available, "W" = Weekend, "H" = Holiday, etc... AND each character space represents the day of the year; the first space would be 1/1, and the 365th would be 12/31 (assuming no leap year). Each row is a year and work center. I would love to have this data normalized where each row represents the date/workcenter/availability. Would anybody be able to point me in the right direction?

 

[Micron]

Rather than me/us guessing and getting the data picture wrong, you could post examples of the field data? Don't wrap entries in quotes if they are not there, but do include any separators if they are not just spaces. I'm guessing W9/15 would be one example (no zero before the nine), but what is the separator? I suspect you will need a function to evaluate an array or a custom collection.