SYSTEMS
​
Data Cleaner File(s)
​​​
​
THE PRODUCT
​​​​​​​​
Import directly into the file and / or copy and paste scripts and script steps into your own systems to check and clean email addresses, phone numbers, dates, currencies, and amounts more efficiently, quickly, and safely
​​
A ready-to-use Claris FileMaker .fmp12 file that accelerates data validation and cleanup.
​
Drop the scripts into your workflows to catch and block errors, standardise fields, and combine data from one or multiple sources quickly.
​
How it works
​​
Scripts are included, including demos of the script usage, inputs, and outputs. The scripts or elements can be copied and pasted in other systems by the user. Or the file can be used to help process the user's data, without having to insert the features (functions, script steps, and scripts) into any other system.
​
​No custom functions are required- primarily script based, using native script steps and functions.
​
Subscription & Updates
​
Your purchase includes any updates published to the file, sent to you by email, within each year of payment.
​
There is no guarantee of future updates.
​
Cancellation will lose access to the greatly discounted pricing for subsequent years.
​
Subscriber requests are likely to be given some priority for consideration for inclusion in future releases.
​
Licence
​
For use by the entity that makes the purchase only. If the item or its parts or modifications thereof are used by other entities, those entities must also make a purchase.
​
The work may be used by but not stated as attributable to the user or deployer.
​
Requirements
​
Modest technical skills are required to make use of the processes include in the file, which is totally unlocked.
​
FileMaker Pro is required to open, run, and copy/extract/modify elements of the file. FileMaker must be purchased separately and can be purchased in various perpetual (permanent) or subscription forms directly from the vendor at Claris.com. We are entitled to sell Claris licences but we ordinarily do not discount them and we ordinarily recommend direct purchase from Claris (an Apple Inc. subsidiary).
​
Minimum version required to open and use the file is FileMaker Pro 12, but a later version may be needed for some features.
​
Disclaimers
​
No warranty of any kind is included. You are fully responsible for safeguarding your data and systems and anything delivered to you is entirely to be consumed and used at your risk, including if and where the content is used for all manner and ranges of activity.
US$ 124.99 for the file and a year of updates, with each update sent to you directly to you by email - no need for logins, downloads, or licence keys.
​​
Second year guaranteed at $49.99 only.
​​
Potential automatic discounts applied on renewal thereafter. Renewal pricing thereafter published at least 45 days before renewal.
​​
Cancellation will likely lose access to the discounted subsequent years.



​
​
WATCH THE BUILDS ​
Build stage 1
​
​
WATCH THE BUILDS ​
Build stage 2
Names of scripts up to and including this point (ordinarily indicative of functionality)
​
AssumingNoTypoCouldBeAValidDDdashMMdashYYYYDate
AssumingNoTypoCouldBeAValidDDdotMMdotYYYYDate
AssumingNoTypoCouldBeAValidDDslashMMslashYYYYDate
AssumingNoTypoCouldBeAValidMMdashDDdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdashMMdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdotMMdotYYYYDate
AssumingNoTypoDefinitelyIsAValidDDslashMMslashYYYYDate
AssumingNoTypoDefinitelyIsAValidMMdashDDdashYYYYDate
CleanupRemoveDuplicateAtSign
CleanupRemoveDuplicateSpaces
CleanupStripToNumberOnly
ImportTypeAJDAEJCMBaseRefreshCurrentRecord
ImportTypeAJDAEJCMRefreshAllRecordsInTableContextAgnostic
IsAValidYYYYdashMMdashDD
IsAValidYYYYslashMMslashDD
TextLeadsWithAPlusSign
WarningEmailAddressInvalidatedByHavingNoAtSign
​
​​​
WATCH THE BUILDS​
Build stage 3
Introduction of the ISO 4217 currency code standards to the file. Download the latest here:
More information available here:
https://www.iso.org/iso-4217-currency-codes.html
​​
(Use of all, including external sources, is entirely at the user's own risk)
Names of scripts up to and including this point (ordinarily indicative of functionality)
​
AssumingNoTypoCouldBeAValidDDdashMMdashYYYYDate
AssumingNoTypoCouldBeAValidDDdotMMdotYYYYDate
AssumingNoTypoCouldBeAValidDDslashMMslashYYYYDate
AssumingNoTypoCouldBeAValidMMdashDDdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdashMMdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdotMMdotYYYYDate
AssumingNoTypoDefinitelyIsAValidDDslashMMslashYYYYDate
AssumingNoTypoDefinitelyIsAValidMMdashDDdashYYYYDate
CleanupRemoveDuplicateAtSign
CleanupRemoveDuplicateSpaces
CleanupStripToNumberOnly
ConvertCurrencyInformationHighCertaintyToAnISO4217Code
ImportTypeAJDAEJCMBaseRefreshCurrentRecord
ImportTypeAJDAEJCMRefreshAllRecordsInTableContextAgnostic
IsAValidYYYYdashMMdashDD
IsAValidYYYYslashMMslashDD
TextLeadsWithAPlusSign
WarningEmailAddressInvalidatedByHavingNoAtSign
WarningTextHasNoAtSymbol
WarningTextHasNoTextAfterAtSymbol
WarningTextHasNoTextBeforeAtSymbol
​
​​
WATCH THE BUILDS​
Build stage 4
Currency number processing
Forcing at least 2 decimal places
Forcing in thousands separators
​
(Use of all, including external sources, is entirely at the user's own risk)
Names of scripts up to and including this point (ordinarily indicative of functionality)
​
AddThousandsSeparatorsToANumberAsTextThatAlreadyHasAtLeast2DecimalPlacesAfterAPeriod
AssumingAtLeastOneCommaAndAtLeastOnePeriodGiveWhichOneAppearsLast
AssumingNoTypoCouldBeAValidDDdashMMdashYYYYDate
AssumingNoTypoCouldBeAValidDDdotMMdotYYYYDate
AssumingNoTypoCouldBeAValidDDslashMMslashYYYYDate
AssumingNoTypoCouldBeAValidMMdashDDdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdashMMdashYYYYDate
AssumingNoTypoDefinitelyIsAValidDDdotMMdotYYYYDate
AssumingNoTypoDefinitelyIsAValidDDslashMMslashYYYYDate
AssumingNoTypoDefinitelyIsAValiMMdashDDdashYYYYDate
CleanupRemoveDuplicateAtSign
CleanupRemoveDuplicateSpaces
CleanupStripToNumberOnly
ConvertCurrencyInformationHighCertaintyToAnISO4217Code
EnsureEndsWithAtLeast2DecimalPlaces
FilterInCommasAndPeriodsAndNumbersOnly
ImportTypeAJDAEJCMBaseRefreshCurrentRecord
ImportTypeAJDAEJCMRefreshAllRecordsInTableContextAgnostic
IsAValidYYYYdashMMdashDD
IsAValidYYYYslashMMslashDD
IsThereAnEore
IsThereAnyCharacterIncludingSpacesOtherThanACommaOrPeriodOrNumber
IsThereAtLeastOneComma
IsThereAtLeastOneCommaAndAtLeastOnePeriod
IsThereAtLeastOnePeriod
QuantityOfCommas
QuantityOfPeriods
RemoveCommasAndAcceptAPeriodAsADecimalInstigatorAndReturnAsANumber
RemovePeriodsAndAcceptACommaAsADecimalInstigatorAndReturnAsANumber
TextLeadsWithAPlusSign
WarningEmailAddressInvaidatedByHavingNoAtSign
WarningTextHasNoAtSymbol
WarningTextHasNoTextAfterAtSymbol
WarningTextHasNoTextBeforeAtSymbol
​