||User ID |Group | Q1 | Q2 | Q3 | Q4 |... | 1234 |no group| 30/06/14,25/08/14,| gs,gm,cl&h | either|s1 |... | | | 27/07/14 | | | |...
我现在需要以新的方式显示现有数据.需要拆分单元中的信息,以便在单元中存在多个信息位的情况下,创建新行.不确定描述它的最佳方式,但以上面的例子为例,我需要它看起来像这样:
||User ID |Group | Q1 | Q2 | Q3 | Q4 |...| 1234 |no group| 30/06/14| gs | either|s1 |...| 1234 |no group| 25/08/14| gm | either|s1 |...| 1234 |no group| 27/07/14| cl&h | either|s1 |...
基本上,每行使用相同的UserID,Group等,但每个Q1,Q2等不同.
这是我到目前为止用于实现顶级示例的代码.
'' sql to get data sql = "select * from table where (datestamp > '" & startDate & "') AND (datestamp < '" & endDate & "') ORDER BY datestamp"Set fIEldTitles = CreateObject("Scripting.Dictionary")fIEldTitles.Add "userID","User ID"fIEldTitles.Add "grp","Group"fIEldTitles.Add "q1","Q1"fIEldTitles.Add "q2","Q2"fIEldTitles.Add "q3","Q3"fIEldTitles.Add "q4","Q4"fIEldTitles.Add "q5","Q5"fIEldTitles.Add "q6","Q6"fIEldTitles.Add "q7","Q7"fIEldTitles.Add "q8","Q8"fIEldTitles.Add "q9","Q9"fIEldTitles.Add "qOrder1","qOrder1"fIEldTitles.Add "qOrder2","qOrder2"fIEldTitles.Add "qOrder3","qOrder3"fIEldTitles.Add "qOrder4","qOrder4"fIEldTitles.Add "datestamp","Date Stamp"fIEldTitles.Add "QID","QID"fIEldTitles.add "y5grp","Year 5 Group"' get the table HTMLdataString = createDatatablesql(fIEldTitles,sql,"")
我一直试图想出一种方法,使用’left(string,length)’来删除开始文本并复制行,但如果字符串长度不同(如Q2),我不能一直这样做.任何人都能指出我正确的方向吗?
解决方法 纯粹是为了向您展示方法,这可以满足您的需求,不确定我是否同意以正确的方式存储数据,但希望这有助于SELECTdisTINCT ROWID,trim(regexp_substr(Q2,'[^,]+',1,LEVEL)) decodedFROM(select'1234' as USER_ID,'NO GROUP' as "GROUP",'30/06/14,27/07/14' as Q1,'qs,cl&h' as Q2,'either' as Q3,'s1' as Q4fromdual) X CONNECT BY trim(regexp_substr(Q2,LEVEL)) IS NOT NulLORDER BYROWID;总结
以上是内存溢出为你收集整理的html – 我需要拆分一系列’varchar’响应,以便在创建DataTable时它显示为新行?全部内容,希望文章能够帮你解决html – 我需要拆分一系列’varchar’响应,以便在创建DataTable时它显示为新行?所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)