Split text into different columns.

Purpose

This app can be used to split a column of text into multiple columns

Installation

Download Text to Columns.opx file, then drag and drop it onto the Origin workspace.

Operations

Input

1. Input Column: Specify the range to separate the contents
2. Include Other Column(s): Specify whether to include other columns with output
3. Other Column(s): Specify the columns to be copied with output

Column Separator

• Delimited: Separate text with the specified character(s) such as commas or tabs.

1. Treat consecutive delimiters as one: If this checkbox is selected, any number of consecutive delimiters will be treated as if they are one.
2. Text Qualifier: Specify the character that encloses values in the source text. The text enclosed in each pair of the qualifier characters is regarded as one value, even when it contains delimiter characters.
3. Remove Text Qualifier from Quoted Data: Specify whether to remove the text qualifier characters.

• Fixed Width: Separate text by a fixed number of characters.
  1. Column Break: Specify the position to separate the text
• Auto: Separate text automatically

Data Format

1. Numeric Separator: Specify the numeric separator to recognize the input numeric data
2. Date Format: Specify the date format for the output columns
3. Time Format: Specify the time format for the output columns
4. Remove Leading zeroes from numbers: Specify whether to remove leading zeros from output columns
5. Force rows to the same size by filling in missing values: Specify whether to add missing values to ensure that each row is of equal size

Output

1. Column Designations: Set the plot designation for all output columns
2. Add Sparklines: specify whether to add sparklines to the output worksheet.
3. Output: Specify the output worksheet

v1.01 updated keywords