New reply on DataCleaner's online discussion forum
(http://datacleaner.org/forum):
Rafael replied to subject 'Filtering data with Validate with string pattern'
-------------------
I check both exits (VALID and INVALID)... All are going to INVALID. I try two
approaches:
First: use the patterns found by the analysis tool (download 4 of them and
select all in the filter parameters using the alternative "ANY") . All data
were INVALID records (no filter results).
Second: Use the following flexible pattern:
^[A-Z]{1,30} [0-9]{1,30} [A-Z]{1,30} [A-Z]{1,30} [0-9]{1,30} [A-Z]{0-9}$
All data were INVALID records (no filter results).
The structure of the example I am using is very simple: DATA --> Validate with
string pattern --> Write EXCEL table.
In DATA, I am selecting only one field that contains words I want to filter
based on the above pattern.
I am sure I am doing something wrong, but I do not understand what...
Any suggestions will be appreciated.
-------------------
View the topic online to reply - go to
http://datacleaner.org/topic/1057/Filtering-data-with-Validate-with-string-pattern
--
You received this message because you are subscribed to the Google Groups
"DataCleaner-notify" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/datacleaner-notify.
For more options, visit https://groups.google.com/d/optout.
