Raw data(Twitter Comment):
@nice#greatwork@fake
very nice portal ncs
#Goodportal@hatsoff to ncs
Output needed:
Col1
@nice
#greatwork
@fake
null
#Goodportal
@hatsoff
want to extract only those words which contains special character in single coloum .
which ever comment does not contain special character then show null.
... View more