Setting regular expressions and finalize the analysis
Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
You can add one or more regular expressions to one or more of the analyzed
columns.
Before you begin
An analysis of a delimited file is open in the analysis editor in the Profiling perspective.
Procedure
Define the regular expression you want to add to the analyzed column.
In this example, the regular expression checks for all words that start with
uppercase:'[A-Z][a-z]*$'
Add the regular expression to the analyzed column in the open analysis editor,
the first_name column in this example.
Save the analysis and press F6 to execute it.
If the format of the file you are using has problems, you will have an error
message to indicate which row causes the problem.
The detailed analysis results view shows the generated graphics for the
analyzed columns accompanied with tables that detail the statistic
results.
Below are the tables and the statistics graphics in the Analysis
Results tab for the analyzed first_name column
in the procedure outlined in Defining the columns to be analyzed in a file.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!