S) Normalise scenario --> Input: 1,a,b,c,2,d,e,f,g
Input: 1,a,b,c,2,d,e,f,g Output: field1 field2 1 a 1 b 1 c 2 d 2 e 2 f 2 g input---->normalize--->output type temporary_type = record decimal("") v_col1; decimal("") v_col2; end; out::length(in) = begin out :: length_of(string_split(in.col, ",")); end; temp::normalize(temp, in, index) = begin temp.v_col1 :: if (string_is_numeric(string_split(in.col, ",")[index])==1) string_split(in.col, ",")[index] else temp.v_col1; temp.v_col2 :: string_split(in.col, ",")[index]; end; temp::initialize(in) = begin temp.v_col1 :: 0; temp.v_col2 :: 0; end; out::finalize(temp, in) = begin out.col1 :: temp.v_col1; out.col2 :: temp.v_col2; end; ...