top of page

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.

Screenshot 2025-10-09 at 09.48.10.png

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.

Data Imports, Inputs, Cleaning, and Outpouts
Safeguards, Standardisation, and Formatting Scripts
ISO standards e.g. ISO 4217

 

​

​

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:

https://www.six-group.com/en/products-services/financial-information/market-reference-data/data-standards.html

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

​

 

​​Group Level Contact Details

​

New York

 

​+1 (212) 858-9246

​

newyork@workaholic.group

​

Suite 1117

183 Madison Avenue

New York 10016

Hong Kong

 

+852 2338 8518

​​

hongkong@workaholic.group

​​

Suite 1104

Crawford House

70 Queen's Road Central

London

 

+44 (0)20 7183 2159

​

london@workaholic.group

​

207 Regent Street

London W1B 4ND

​

Sydney

 

+61 (0) 2 8294 9212

​

sydney@workaholic.group

​

Suite 1301

World Tower Commercial

89 Liverpool Street

Sydney NSW 2000

​

​

Contact

​

Upload File
Upload supported file (Max 15MB)
Service Interests

Submission successful

 

 

W

 

WORKAHOLIC GROUP

EST. 2013

​

All details, products, and services are provided strictly E&OE and without warranty.

The Entity you deal with depends on the product, service, and their jurisdiction at the time of purchase.

​

bottom of page