sublime text能否进行类awk操作？

Question

例如我要将

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

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

Answer 1

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

Answer 2

第一步可以更简单点，因为所有需要复制的文本是左对齐的，可以用crtl+鼠标中键进行块选择