I would like to transform data as shown below. The idea is that M and W are associated with 8:00 start and 9:15 end (M,W=8:00-9:15). Tuesday and Thursday are associated with 14:45. M and W are currently separated by a comma, So are T and TH. M,W are separated from TU and TH by a ;
Current Structure > Desired Structure
โMEETING_DAYSโ: โM,W;TU,THโ, >> โMEETING_DAYSโ: โM**;W;TU;TH",
โMEETING_START_TIMESโ: โ08:00;14:45โ, >> "08:00;08:00**;**14:45;**14:45โ,
โMEETING_END_TIMESโ: โ09:15;16:00โ, >> 09:15;09:15;16:00;16:00
So, comma values are grouped semi colon separated values are not.
Iโm not sure Iโm explaining this well, but hoping there is an approach that can help with this.
