How to Split Text with No Code

Using the wrong tools can be a bit like playing golf with gardening tools. Gimme putts? Not when you're using the back of a rake...

If you've ever needed to split text to rows, you can probably relate. With spreadsheets or SQL, you might as well be using a shovel. That's why data analysts like you need a better tool ??

Splitting Text

Today, we'll show you just how easy this is in Savant. In our example, we have the rosters for two NBA teams with the players listed in a single text field:

This format is readable for humans, but what if your analysis needs each player separated out?

You'd have to write a lot of substring expressions if your spreadsheet didn't support text to column. And with SQL, you might have to hard-code five columns with split functions and hope the number of players doesn't change.

Text Splitting Made Easy with Savant

With Savant, you simply select the split tool ? and enter a separator. Voila! Each player is now in their own column. Now you can work with each player separately in the data.

Split Text to Row in 1?? Click

Each player is separated ? but your analysis probably needs each player in their own row.

This is hard in most spreadsheets and SQL. You could manually cut and paste data, do a lot of union-ing or write a fancy script...but that's error-prone and time-consuming.

Don't worry, Savant has you covered! In the split tool, just select the split to row option. One-click, no code and you're done ??

Need to split text? Try Savant now!