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
Preview:
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