DataPrep allows you to split the columns based on the given input. A column can be split into multiple columns using a delimiter based on the chosen split option.

You can divide a column into multiple columns using the Split transform. 

To split a column:

1. Right-click the column name and select Split from the context menu. 

2. Choose one of the Split options and provide the required inputs based on which the column should be split. 

The options available are:
  1. Start and end index
  2. Start and end length
  3. Delimiter
  4. Regex
  5. Whitespaces 
3. Let's take a look at the inputs required for some of the options listed above.

Start and end index: 
Start index - The index at which the delimiter starts. The default start index is 1.
End index - The index at which the delimiter ends.

Start index and length: 
Start index - The index at which the delimiter starts. The default start index is 1.
Length - The character length of the delimiter.

Delimiter - Split using the text or pattern as the delimiter.
Starting delimiter -  Split using the text or pattern matched starting from the start delimiter.
Ending delimiter -  Split using the text or pattern matched before the ending delimiter. 

Regex pattern - Enter the delimiter using regular expression.

Ignore case - Turn off case sensitivity when matching text or pattern.
Number of matches to split - Specify the number of matches to be split as columns. The minimum number is 2.

4. You can also choose to store the extracted value in a 'column' or as a 'list' using the Store output as option.
5. DataPrep shows a live preview of the changes made to the column.

6. You can apply this transformation to multiple columns. Select the columns using the + option under the Columns to apply section. 

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                Zoho SalesIQ Resources

                    Zoho TeamInbox Resources

                              Zoho DataPrep Resources

                                Zoho DataPrep Demo

                                Get a personalized demo or POC

                                REGISTER NOW

                                  Design. Discuss. Deliver.

                                  Create visually engaging stories with Zoho Show.

                                  Get Started Now

                                                        • Related Articles

                                                        • Smart selection

                                                          Zoho DataPrep offers you an array of suggestions using the pattern matching notations when you select portions of the column data that you wish to transform.  Note: If you are not familiar with pattern matching in DataPrep, read about it here. You ...
                                                        • Find and Replace

                                                          Find and replace values in your column using the replace transform. You can find the value to replace by matching the value using different options available and replace it with your input. To find and replace column data: 1. Right-click the column ...
                                                        • Count

                                                          DataPrep allows you to count the occurrence of data in a column based on the condition given. You can count the values that match your selection based on the different patterns that fit your selection.  To count the desired value in a column: 1. ...
                                                        • Extract from text

                                                          Zoho DataPrep offers options to identify and extract a subset of the data from a column. You can extract very specific portions of the column data using the extract transform. For example, your column contains a mixture of letters and numbers, but ...
                                                        • Functions available to add formula columns

                                                          Abs abs(num) Returns the absolute value of the numeric value. Parameters Name Description num Decimal Parameter must be a numeric value from a column or an expression that returns a number. Example Function Result abs(-1) 1 Div ...



                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                        CRM Tips

                                                        Make the most of Zoho CRM with these useful tips.

                                                          Zoho Show Resources