Preview:
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
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter