Regex that remove painting logic and just keep the column name

Question

I have below String and I want to remove formatting and keep just column name. Can someone suggest regex for this please?

"XYZ_Col,to_timestamp(CREATE_DT,'yyyyMMdd HHmmss')CREATE_DT,ABC_Col,DEF_Col"

to

"XYZ_Col,CREATE_DT,ABC_Col,DEF_Col"

Thanks in advance

i meant im transforming date column here. so I just want to remove this formatting — dileepvarma, May 01 '20 at 21:27

score 0 · Accepted Answer · answered May 02 '20 at 23:43

0

I got the solution.

regexp_extract(regexp_replace(column_name, \"\'\", \"\\\\''\") , '[^)]*$',0)

answered May 02 '20 at 23:43

dileepvarma

1 Answers1