framework
framework copied to clipboard
Does Frictionless Py support .txt format for validation?
Description:
I am facing an issue where my CSV date field (YYYY-MM-DD) is being auto-converted to MM/DD/YYYY when opened in Excel. The only way to prevent this is by saving the file as a .txt format.
I would like to know if Frictionless Py supports .txt files for validation. If not, is there a recommended way to validate CSV files while preserving the original date format?
Steps to Reproduce:
- Create a CSV file with a
YYYY-MM-DDdate field. - Open the file in Excel (which auto-converts the date).
- Save the file as
.txtinstead of.csvto prevent conversion. - Try validating the
.txtfile using Frictionless Py.
Expected Behavior:
- Frictionless should recognize
.txtfiles for validation. - The date format should not be altered during validation.
Additional Context:
Would appreciate any guidance on handling CSV validation while preserving date formats. Thanks!