Search

Close

Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

227

Yet a slightly different number of records (16322 for me)

No option to install the text mining tools for now

Solution Attached

I get slightly different results (but very similar)

Assume it comes down to the way the data was cleaned and the set up of the sentiment analysis tool.

I have tried to create an interactive chart but couldn't change the colours to what I wanted by using split by type and not separate layers 😔

Here is my solution to Challenge #227.

Thanks

Sapna Gupta

Definitely not an optimal solution but it gets to a result that I would be happy to do text analysis on. Video solution here: https://www.youtube.com/watch?v=ddJHPlmZXOQ&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=31

Here is the first part... I don't have access to the extra tools

Submit my solution, thanks!

My regex string, lol =))) :

REGEX_Replace([body], "<div[^>]*>|<\/div>|<p>|<\/p>|<a[^>]*>|<\/a>|<noscript>|<\/noscript>|<img[^>]*>|<\/img>|<span[^>]*>|<\/span>|<ol>|<\/ol>|<li>|<\/li>|<BR \/>|\\n|\(Highlight to read\)|<strong>|<\/strong>|Spoiler|<strike>|<pre>|<\/strike>|<\/pre>|<font[^>]*>|<\/font>|<LI-EMOJI[^>]*>|<\/LI-EMOJI>", "")

My regex string, lol =))) :REGEX_Replace([body], "<div[^>]*>|<\/div>|<p>|<\/p>|<a[^>]*>|<\/a>|<noscript>|<\/noscript>|<img[^>]*>|<\/img>|<span[^>]*>|<\/span>|<ol>|<\/ol>|<li>|<\/li>|<BR \/>|\\n|\(Highlight to read\)|<strong>|<\/strong>|Spoiler|<strike>|<pre>|<\/strike>|<\/pre>|<font[^>]*>|<\/font>|<LI-EMOJI[^>]*>|<\/LI-EMOJI>", "")

Unfortunately I don't have 2020.2.

Here is my solution !