sqlite用substr和instr截取特定分隔符的字符串
原始数据格式 起点-终点-单位
substr(Help, 0, instr(Help, '-')) as Start,substr(substr(Help, instr(Help, '-')+1), 0, instr(substr(Help, instr(Help, '-')+1), '-')) as Finish,substr(Help,instr(Help,'-')+instr(substr(Help,instr(Help,'-')+1),'-')+1) as Units
处理过以后，就分成了单独的起点列、终点列和单位列
因篇幅问题不能全部显示，请点此查看更多更全内容