当前位置: 代码迷 >> PB >> PB取逗号后的字符串,该如何解决
  详细解决方案

PB取逗号后的字符串,该如何解决

热度:86   发布时间:2016-04-29 08:04:51.0
PB取逗号后的字符串
string ls_string,ls_spbm,ls_tradetime,ls_lsj,ls_sl
ls_string=ls_spbm+','+ls_tradetime+','+ls_lsj+','+ls_sl(例如:XXXX,2012-08-08,XXX,XXXXX;时间长度为10,其余字符串长度没限制)

ls_spbm= left(ls_string,pos(ls_string,',')-1)
ls_tradetime= mid(ls_string,pos(ls_string,',')+1,10)
ls_lsj= ?
ls_sl= mid(ls_string,lastpos(ls_string,',')+1)

ls_lsj的值怎么取?

------解决方案--------------------
楼主要拆分逗号分隔的字符串吗?

string ls_yuan,ls[],ls_msg
int li_start,li_end,li_i

ls_yuan="XXXX,2012-08-08,XXX,XXXXX"

ls_yuan=ls_yuan+","

li_start=1
li_end=pos(ls_yuan,",",li_start)

do while li_end<>0
li_i=upperbound(ls[]) + 1
ls[li_i]=mid(ls_yuan,li_start,li_end - li_start)
li_start=li_end+1
li_end=pos(ls_yuan,",",li_start)
loop 

for li_i=1 to upperbound(ls[])
ls_msg=ls_msg+" "+ls[li_i]
next 

messagebox("提示",ls_msg)



------解决方案--------------------
ls_string=ls_spbm+','+ls_tradetime+','+ls_lsj+','+ls_sl

还有一个简单的,以上语句先写成:

ls_string=ls_spbm+','+ls_tradetime+'.'+ls_lsj+';'+ls_sl

取值后,把"."";"替换回去就行了。
  相关解决方案