DATA Step, Macro, Functions and more

Extracting strings from text

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Extracting strings from text

[ Edited ]

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.

 

 


Accepted Solutions
Solution
‎08-31-2016 09:06 AM
Super User
Posts: 19,772

Re: Extracting strings from text

Posted in reply to Milindbhorge

All Replies
Solution
‎08-31-2016 09:06 AM
Super User
Posts: 19,772

Re: Extracting strings from text

Posted in reply to Milindbhorge
Super Contributor
Posts: 266

Re: Extracting strings from text

Good catch ...same question asked twice by different person

New Contributor
Posts: 2

Re: Extracting strings from text

yea that true one of my frd(atul) only asked tht que ....

 

but ans were nt appropriate .

Super User
Super User
Posts: 7,942

Re: Extracting strings from text

Posted in reply to Milindbhorge

Perhaps it would be a good I dea to close of the other thread - mark one of the responses as the solution, then in this post update it to reflect what the input data is, and also explain why the given solutions are "nt appropriate".  Please use full examples of what you want.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 297 views
  • 0 likes
  • 4 in conversation