“2,4-滴异辛酯/2,4-D-ethylhexyl:7%;莠去津/atrazine:28%;乙草胺/acetochlor:42%”这字符串中三种有效成分,每种有效成分间用';'分隔。
t=table(["2,4-滴异辛酯/2,4-D-ethylhexyl:7%;莠去津/atrazine:28%;乙草胺/acetochlor:42%", "2,4-滴异辛酯1/2,4-D-ethylhexyl:7%;莠去津1/atrazine:28%;乙草胺1/acetochlor:42%"] as ContentInfo,1..2 as id )
select split(ContentInfo, ";") as `c1`c2`c3 from t
执行select语句报:
The first argument for 'split' must be scalar string。
然后我用each函数如下:
select each(split,ContentInfo, ";") as `c1`c2`c3 from t
执行报错:
Not allowed to create a matrix with type STRING