Text Cleaning

This template will clean text, format columns (string data type only), adjust capitalization and remove numbers, letters, punctuation, and blanks from a string. These actions can be a vital step in data preparation and Exploratory Data Analysis.

Features

• Clean your Data
• Regex Data Function in R

A template is an analysis file created in TIBCO Spotfire. The intended use is to replace the data and utilize the configured visualizations and calculations.

1. Download the template to your personal machine. Login into your own Spotfire server and open the downloaded file.
2. Review the tables shown on the data load page. These are the tables you'll replace.
3. Replace the data with another Excel sheet or connect the template directly to your database or platform.
4. Customize with your own data. You are free to embed and incorporate your template into other projects.
5. All done!