Welcome To Ask or Share your Answers For Others

如何将股票代码格式化成类似000001.SZ这种格式(后面的.SZ或.SH根据exchangecd判断)

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

图片.png

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

2.0k views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Jan 27, 2021 by 深蓝 (71.8m points)

用format和iif，例如：

t=table(1 2 as ticker,`XSHE`XSHG as exchanged)
select format(ticker,"000000")+iif(exchanged==`XSHE,`.SZ,`.SH) from t

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...