shell脚本提取关键字

Question

遇到的问题，有一段sql语句：

select a.l_date as deal_date,0 as deal_time,a.vc_deal_no as deal_no,a.l_entrust_serial_no as entrust_no,
a.c_market_no as market_no,a.vc_realdeal_code as stock_code,a.vc_report_code as etf_first_code,concat('0',a.c_entrust_direction) as entrust_direction,
a.l_deal_amount as deal_amount,a.en_deal_balance as deal_balance,a.en_deal_price as deal_price,a.en_fee as total_fee,b.l_extsystem_id as module_id,
b.vc_third_reff as third_remark,b.l_operator_no as operator_no,b.l_batch_serial_no as batch_no,a.vc_report_direction as report_direction "
from tetfrealdeal a, tentrusts b where a.l_entrust_serial_no = b.l_entrust_serial_no and b.l_operator_no in ({{operator_no_list}})

我想把 （as空格key空格）中的key（如deal_date，deal_time等）全部提取出来返回给其他函数，这应该怎么写shell脚本呢，是遍历这条sql，还是有啥字符截取的方法呢？

Answer 1

先用下面的第一句确认一下是不是正确，然后用第二句输出结果

grep -P "(?<= as )[a-z_]+"
grep -Po "(?<= as )[a-z_]+"