sublime-text - sublime text能否进行类awk操作？

问题描述

问 题

例如我要将

SELECT LKP.ROW_SKEY
,LKP.SOURCE_ID
,LKP.SYS_BSN_KEY
,LKP.DELETE_FLG
,LKP.SRC_CREATE_DT
,LKP.SRC_UPDATE_DT
,LKP.SRC_CRT_BY_ID
,LKP.SRC_UPD_BY_ID
,LKP.W_INSERT_DT
,LKP.W_UPDATE_DT
FROM BIDW.TD_VAT_ITEM_HIS LKP
,DW_STAGE.TM_VAT_ITEM_HIS TM
WHERE 1=1
AND LKP.SOURCE_ID=TM.SOURCE_ID
AND LKP.SYS_BSN_KEY=TM.SYS_BSN_KEY

变成

SELECT LKP.ROW_SKEY AS ROW_SKEY
,LKP.SOURCE_ID AS SOURCE_ID
,LKP.SYS_BSN_KEY AS SYS_BSN_KEY
,LKP.DELETE_FLG AS DELETE_FLG
,LKP.SRC_CREATE_DT AS SRC_CREATE_DT
,LKP.SRC_UPDATE_DT AS SRC_UPDATE_DT
,LKP.SRC_CRT_BY_ID AS SRC_CRT_BY_ID
,LKP.SRC_UPD_BY_ID AS SRC_UPD_BY_ID
,LKP.W_INSERT_DT AS W_INSERT_DT
,LKP.W_UPDATE_DT AS W_UPDATE_DT
FROM BIDW.TD_VAT_ITEM_HIS LKP
,DW_STAGE.TM_VAT_ITEM_HIS TM
WHERE 1=1
AND LKP.SOURCE_ID=TM.SOURCE_ID
AND LKP.SYS_BSN_KEY=TM.SYS_BSN_KEY

有什么插件可以快速操作？

解决方案

选中,LKP. , 然后快捷键 Ctrl+d多光标选中所有 ,LKP.;
→ (右箭头), 再ctrl + shift + →, ctrl+c多光标复制, '→'进入多光标编辑, 空格, 输入 AS,空格 , Ctrl + v 粘贴

这篇关于sublime-text - sublime text能否进行类awk操作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！