Parse Data

Overview

Parse Data is a tool to parse the content in a selected range. The user could also transpose and parse the data in the same form.

Videos

Examples

Here is a step-by-step example of using Parse Data to manipulate original data.

1. Prepare an Excel worksheet with data to parse.

   

2. Open Finplicity, and then click Data Basics > Parse Data. The form of Parse Data will appear, as shown below.

   

3. Select the data to be parsed. In this example, select A1:A6.

4. Select the delimiters. In this example we would check “Comma,” check “Others” and input “&” since the data is separated by comma and the header row is separated by “&.”

5. Select the output method. In this example, select “No transpose (text to columns)” to parse and transpose data at the same time.

6. Select the output location. In this example, select A8.

   

7. Now you have finished all the steps in this form, and you can click “Run” to parse data or click “Save” to save this task. The parsed data is shown below.

   

FAQ

• Can I use multiple delimiters?

Yes. If there are multiple delimiters in the data, please make sure to select each of them in Parse Data form.

• Will parsed data overwrite existing cells?

Yes. Parsed data will overwrite all original data in the output range if there is any. Select the original data range as the output location if you wish to replace the data with parsed data.