select *, regexp_replace(t1, '[[:digit:]]+', '','g') -- remove all number in t1 from ( select *, regexp_replace(name, '[^a-zA-Z0-9]+', '','g')as t1 -- remove all special lcharacter ,regexp_replace(number, '[^a-zA-Z0-9]+', '','g') as t2 --remove all special character from remove_specialcharacter_csv as rsc ) tt