Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Data Format in Annotation

Summary

Identify whether the a Flow annotation contains instances of particular arbitrary text. This example rule looks for dates.

Description

Identify whether the a ‘Job Description’ annotation contains instances of particular arbitrary text. You can modify this rule to get it to seek out any text your team wants to prevent passing compliance. This example rule looks for text matching the following date formats:

FormatDescription
YYYY-MM-DD, YYYY/MM/DD, YYYY MM DDYYYY-MM-DD format with / or - as a delimiter
YYYY-MMM-DD, YYYY/MMM/DD, YYYY MMM DDMonth format can be MM, MMM, MMMM, or MON
YYYY-MMMM-DD, YYYY/MMMM/DD, YYYY MMMM DDMMM and MMMM are Excel Syntax
DD-MM-YYYYSimilar to YYYY-MM-DD
MM-DD-YYYYSimilar to YYYY-MM-DD (common US date format)

Actions

Remove or alter the text that references a date.


Back to top

Copyright © 2017-2024 Data Migrators Pty Ltd.