View as a Web page

December 2013 subscribe/unsubscribe  |
If You Learn Only One Formula Editor Function, Word() Is the One »

Word() FunctionQuick quiz: How many Character functions are available in the JMP Formula Editor? A whopping 42! Needless to say, if you've got a character column and want to change it somehow, JMP probably has a function to do it for you.

Nine of those 42 functions are all (or mostly) about extracting some portion of a character value. Admittedly, this is one of the most common operation – taking some part of a larger string of characters. This is known as a substring.

The most obvious function for this is the Substr() function, but this function requires that you know exactly where the part you're interested in lies in the larger string. It also means that the part you want has to be in the same place in every string.

That's why I love the Word() function. It's amazingly flexible and works the way that I think.

The Word() function takes two required arguments and one optional.

Word(n, "text", <"delimiters">)

The Word() function divides the text up into words based on the delimiters you specified and returns the nth word. If you don't specify the delimiters argument then the default delimiter is the same one we use to separate words in sentences: a space.

The key to taking advantage of the Word() function is to view your strings as "sentences" and think abstractly about choosing delimiters.

Read the complete post, with examples, in the JMP Blog.

Tips & Tricks
Have you tried... »

…using the Value Ordering column property? This property allows you to set the order in which categorical values are displayed. When you analyze and graph categorical data, they are displayed in alphabetical order. If this order isn’t appropriate for your data, you can use the Value Ordering property to display them in the correct order. To add this property to a column, open the Column Info dialog and select the Value Ordering property from the drop-down list. Move the values up or down in the list to change the order. Voilà! The next time you run your analysis, these values appear in that order.

Value Ordering Column Property

Live Webcasts
Learn More »

Getting Started with JMP®
1 p.m. ET (10 a.m. PT)
Dec. 6, 13, 20

Mastering JMP®
2 p.m. ET (11 a.m. PT)
Dec. 6, 13

Analytically Speaking
1 p.m. ET (10 a.m. PT)
Dec. 11, featuring International Year of Statistics Panel

Upcoming Courses
JMP Training »

NEW!   Analyzing Marketing Data: Going Beyond Tabs and Bar Charts with JMP®
March 17-19
San Francisco, CA

Application Development Using the JMP® Scripting Language
Jan. 23-24, Jan. 27-28
Live Web Classroom

JMP® Software: Data Exploration
Jan. 16-17
Live Web Classroom

JMP® Software: ANOVA and Regression
Jan. 28-31
Live Web Classroom

JMP® Software: Analyzing Multidimensional Data
March 6-7
Live Web Classroom

Your Subscription
You are receiving this e-mail because you have subscribed to JMP Newswire or have requested information about JMP. If you are not subscribed and would like to stay informed about JMP by receiving product information, training information, and news about upcoming releases, please go to our subscription page.
Don't miss the JMP updates you requested! Please add domain to your safe sender list.
Report Delivery Problem |  Privacy Statement |  Contact the Editor |  Other Subscriptions

To contact JMP via postal address:
SAS Institute Inc., JMP Software, SAS Campus Drive, Cary, NC 27513 USA
ATTN: Legal Division/Privacy Manager.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks
of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and
product names are trademarks of their respective companies.

Copyright © SAS Institute Inc. All rights reserved.