Example of demo-ing custom regex?

Question

Greetings! I recently did a demo of walking through custom regex tool. I did a couple of basic examples of how this tool works on sample data (thanks Brady!) but I didn't have anything really interesting to show - it was enough to show them how to use the tool, but not really to WOW them. Does some one have a favorite demo of using custom regex?

Jordan_Hiller · Answer

I did some work with custom regex to clean up tweets for text analysis -- pretty simple, but effective.

The table attached contains tweets about REI, the outdoors gear shop. The Text Explorer script has the custom regex embedded.

Haven't used this in a customer-facing demo, not sure how well it would work for your needs.

J

REItweets.jmp

DonMcCormack · Answer

I don't have a specific demo, but I do have a number of examples I could share. One thing I use for is replacing extraneous characters, like multiple spaces with a single space

Regex(textToParse,"[ ]{2,}"," ",Global Replace)

or tabs, carriage returns, line feeds, with a space

Regex(textToParse,"[	
]+"," ",Global Replace)

Regex is an extremely powerful tool and Craige Hales has done a phenomenal job implementing it in JMP (even has look ahead and look behind). Not much you can't do, text-wise.

I'm in the process of putting together a Discovery Europe session on prepping data for Text Explorer and will talk about using Regex in a bit of detail. I will be happy to share it when I'm done.