New reply on DataCleaner's online discussion forum (https://datacleaner.org/forum):
Dennis replied to subject 'Numeric' ------------------- For negative numbers, we have the number range filter. For digits or decimals, it depends: Is the validation on the presence of the decimal point, or on the actual number being non-integer? For both, we have pre-made string patterns. If you click "More"/"String patterns"then "Browse in RegexSwap" (third image button from the left), then open the "numbers" tab, there's a few options. Choose "Integer" or "Integer or rounded" depending on what you need. After that, you can use "Validate with string pattern" on the VARCHAR (not the numeric). However, unless this is going directly to an analyzer, I'd again warn against throwing filters at everything. They _will_ interact, and they'll do that with OR-logic, so you easily end up with none of your filters seemingly taking any effect. If you want to transform the values, just run all records through the transformers, don't filter first. ------------------- View the topic online to reply - go to https://datacleaner.org/topic/1170/Numeric -- 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 https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
