For datasets that have a fixed width for each row, determining the column breaks can be more challenging, due to the uncertain number of spaces and tabs between each data element. With enhanced pattern matching, the application can help you identify the appropriate locations to break columns and then trim down the data to eliminate the whitespace padding.
Steps:
The data should now look similar to the following:
Fixed-width dataset after import |
From the drop-down to the right of the column name, select Column Details.
In the Column Details panel, click the Patterns tab.
Click in the All Patterns area.
NOTE: Selecting a specific pattern token will generate suggestions for only that particular token. |
NOTE: If the application has inferred that the dataset is fixed-width, then the All Patterns area is the only available selection. If the dataset is not inferred as fixed-width, you should see multiple categories of patterns. |
Your recipe step might look similar to the following:
You can use the following step to remove the whitespace from each cell value.