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: 17,888

Re: Extracting strings from text


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

Re: Extracting strings from text

Regular Contributor
Posts: 242

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,413

Re: Extracting strings from text

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
  • 286 views
  • 0 likes
  • 4 in conversation